Re: Calender table

FredWamaa · ‎04-22-2020

In power Query Editor the Calender dates are sequential

1/1/2008

1/2/2008

1/3/2008

1/4/2008

1/5/2008

1/6/2008

1/7/2008

when I close the query window I loose 7 days, trying to use calender to calculate ytd,/mtd/qtd

1/1/2008

1/8/2008

FredWamaa · ‎06-15-2020

They discarded the dataset , sorry took this long to reply

v-eachen-msft · ‎04-23-2020

Hi @FredWamaa ,

Could you please share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to OneDrive for Business and share the link here.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

mwegener · ‎04-22-2020

Hi @FredWamaa ,

can you share your Power Query (M) Code?

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials