Home Forums Power Pivot Power Query Date Table

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by  tomallan 1 month, 4 weeks ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #8424

    MrNoob
    Participant
    • Started: 2
    • Replies: 0
    • Total: 2

    Afternoon all,

     

    So I had used Power Query to create my date table.  I like to keep the Excel file cleanish.  HOWEVER… somehow the powerquery date table is now read-only and I need to edit the M code to add 4 more years.  An easy task if it was not forced into read-only mode.  Is there any way to save this.  I have hours of work on this, and super lazy to want to restart.  Working with workarounds for now, but running into an issue that would be fixed if I had them connected to the date table.

     

    If i unload and load it back in and try to reset the connections the datamodel pretty much dies.  I am assuming it is the sameperiodlastyear formulas.

    #8435

    tomallan
    Keymaster
    • Started: 9
    • Replies: 1982
    • Total: 1991

    If you have measures linked to your calendar table, you should move the measures elsewhere before removing the calendar table.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.