Unable to create Week End Date in Direct Query

[Anonymous]

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!

[Anonymous]

You could either use formatting to get the days of the week (using ddd) and go from there.

--Nate

[v-angzheng-msft]

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.

[AlexisOlson · Accepted solution]

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] )

[Greg_Deckler]

@Anonymous Create a measure? Week Ending - Microsoft Power BI Community