Solved: ASAP - Need formula - Page 2

Irussaa · ‎11-10-2019

Hi guys,

Anyone have formulation to generate weekending data like the picture below (rounded in red line)?

I need colum of data that contain week ending date with format just like in the pict attached.

Thank you.

v-eachen-msft · ‎11-11-2019

If you want a DAX formula, you could try the following DAX:

Column =
"W" & WEEKNUM ( 'DateDim'[WeekEnding], 1 ) & " "
    & MONTH ( 'DateDim'[WeekEnding] ) & "/"
    & DAY ( 'DateDim'[WeekEnding] )

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

ASAP - Need formula