Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |