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.
I need to compare the count on a given day to the count in the previous year same day. Compare the data of 5 Mar 2023 to 5 March 2023. How can i achieve this in DAX.
HI @Cevola
Count Previous Year = CALCULATE ( [Count], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
If no Date table then
Count Previous Year =
VAR CurrentDate = MAX ( 'Table'[Date] )
RETURN
CALCULATE ( [Count], 'Table'[Date], = DATE ( YEAR ( CurrentDate ) - 1, MONTH ( CurrentDate ), DAY ( CurrentDate ) ) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
36 | |
21 | |
19 | |
13 |
User | Count |
---|---|
125 | |
39 | |
32 | |
27 | |
24 |