Forum Discussion

Irussaa's avatar
Irussaa
Helper I
6 years ago
Solved

ASAP - Need formula

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 at...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Irussaa ,

     

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

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

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Irussaa ,

 

Replace WEEKNUM ( 'DateDim'[WeekEnding], 1 ) with WEEKNUM ( 'DateDim'[WeekEnding], 2 ). After my tests, it will work.