Forum Discussion
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 Fortnightly_Starting
1/06/2019
15/06/2019
22/06/2019 .....
Regards
Drake
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
2 Replies
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