Forum Discussion

Raul09's avatar
Raul09
Icon for Advocate I rankAdvocate I
8 years ago

Calendar Table invoke dates

Hi everybody,   Well, we are starting a new year of reports!  So, i was updating them then i realized all my MTD calculations stopped working, but only on my new data of 2018. I think is because ...
Need Help
MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

Since you include a screen shot of a Power Query function: this formula creates a table with all dates for 2018:

 

= #table(type table[Date = date],List.Zip({List.Dates(#date(2018,1,1),365,#duration(1,0,0,0))}))
Raul09's avatar
Raul09
Icon for Advocate I rankAdvocate I
8 years ago

 

Thanks for the reply MarcelBeug

 

The real question is how can i edit my calendar to show all dates for 2018 starting in 2017.

 

  • MarcelBeug's avatar
    MarcelBeug
    Icon for Community Champion rankCommunity Champion
    8 years ago

    The screen shot you posted, just included the general information of function List.Dates.

     

    Without you posting your actual code, I won't be able to help you.