Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This has happened after working on
Solved: Re: KPIs visuals Running incredibly slowly - Microsoft Fabric Community
I have some DAX that is basically doing a distinct count on the person ID
And that gives me my total people
I have a date dimension connected by Date Key to Snapshot date key in the fact table. And have another DAX
Solved! Go to Solution.
Hii @DebbieE
Try this for the above senario,
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you
ply try this
m1 =
VAR _LastYear = MAX('Dim Date'[Year]) -1
RETURN
CALCULATE (
SUMX (
VALUES ( 'Dim Person'[Person ID] ),
1
),
'Dim Date'[Year] = _LastYear
)
Yep I had done the DAX slightly wrong and resolved it by the above. Thank you
ply try this
m1 =
VAR _LastYear = MAX('Dim Date'[Year]) -1
RETURN
CALCULATE (
SUMX (
VALUES ( 'Dim Person'[Person ID] ),
1
),
'Dim Date'[Year] = _LastYear
)
Hii @DebbieE
Try this for the above senario,
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you
I already have this and while it works to get back to the same period last year. It doesnt get me back to the last snapshot
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |