Forum Discussion

FredWamaa's avatar
FredWamaa
Regular Visitor
6 years ago

Calender table

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

1/8/2008

 

 
 

3 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    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.

     

  • FredWamaa's avatar
    FredWamaa
    Regular Visitor

    They discarded the dataset , sorry took this long to reply