Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Unable to create Week End Date in Direct Query

Hi Guys,   I am trying to create week end date in PQ. Although I am able to do that it forces me to change the query to 'import'   Any workaround as I need it in DQ. Cheers!    
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I'm not sure you can do it in Power Query but it looks like a DAX calculated column still works:

    EndOfWeek = DatesTable[Date] + 7 - WEEKDAY ( DatesTable[Date] )
v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Anonymous 

Like Greg_Deckler  and AlexisOlson  mentioned above, you can create a measure to do it.

 

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.