Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |