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.
Dear Community,
I have problem on getting the previous month achievement.
Attached pbix which have only Feb and March data, and DAX calculation for their achievement of that month.
Like February have 83.3% while March have 78.3%.
When slicer is select March, previous month will show 83.3% (February).
* I have calendar and link it to the data.
pbix: https://ufile.io/f9otpxbj
Thanks for your attention.
Solved! Go to Solution.
@NickProp28 , I tried like this
Seem to be work
Previous month = CALCULATE([Achievement],DATESMTD(DATEADD('Calendar'[Date],-1,MONTH)))
@NickProp28 , I tried like this
Seem to be work
Previous month = CALCULATE([Achievement],DATESMTD(DATEADD('Calendar'[Date],-1,MONTH)))
User | Count |
---|---|
94 | |
78 | |
73 | |
64 | |
60 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |