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.