Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Would anyone know how to turn this into a YTD formula (excluding the current quarter)?
Thanks
Solved! Go to Solution.
pls try this
=
VAR _today = TODAY()
VAR StartDate = DATE(YEAR (_today),1,1)
VAR EndDate = DATE ( YEAR ( _today ), FLOOR ( MONTH (_today ) -1 , 3 ) + 1 , 1 )-1
VAR Results = CALCULATE([Count of], DATESBETWEEN('Calendar'[Date],StartDate,EndDate))
RETURN
Results
pls try this
=
VAR _today = TODAY()
VAR StartDate = DATE(YEAR (_today),1,1)
VAR EndDate = DATE ( YEAR ( _today ), FLOOR ( MONTH (_today ) -1 , 3 ) + 1 , 1 )-1
VAR Results = CALCULATE([Count of], DATESBETWEEN('Calendar'[Date],StartDate,EndDate))
RETURN
Results
That indeed has worked, well done!
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |