Measure for Fortnightly

[Anonymous]

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 Fortnightly_Starting

1/06/2019

15/06/2019

22/06/2019 .....

Regards

Drake

[v-chuncz-msft · Accepted solution]

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

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