Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure for Fortnightly

Hi Team,   Don't know if someone has already did this. I need a measure for "Fortnightly calculation". I have monthly and weekly but how to build the measure for "Fortnightly". Need a measure for...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    You may use the following DAX to add a calculated column.

    Column =
VAR d =
    MIN ( 'Table'[Date] )
RETURN
    d
        + QUOTIENT ( DATEDIFF ( d, 'Table'[Date], DAY ), 14 ) * 14
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

Anonymous 

 

You may use the following DAX to add a calculated column.

Column =
VAR d =
    MIN ( 'Table'[Date] )
RETURN
    d
        + QUOTIENT ( DATEDIFF ( d, 'Table'[Date], DAY ), 14 ) * 14
Anonymous's avatar
Anonymous
Not applicable
6 years ago

This works, but need one improvement. I need to start my week with sunday but here it is starting with the first date of my tables. If possible let me know else I have already submited the work and the team are happy.

 

Regards

Drake