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.
Hi,
Im trying to do the following:
I have visual with 2 measures:
Solved! Go to Solution.
Hi @Bohumil_Uhrin ,
You can use the following measure, and it will show what you want:
Amortisation value prev =
VAR prev_month = MAX(data[Month])-1
RETURN
calculate([Amortisation value],filter(ALLEXCEPT(data,data[Material]),data[Month]=prev_month))
If this post help, please consider accept it as the solution to help other member find it more quickly.
Best Regards,
Dedmon Dai
is your data[Month] a date field or a number field? what happens if the month is January?
Did you notice that you subtract 1 twice?
data[Month] is number field
yeah, I subtracted twice - I corrected
I have data only for months 3-9. When I select the smallest (3), its the same - blanks.
I shared file on onedrive: https://1drv.ms/u/s!AsS4aATA1W9agqQtzmF_2oMhuMB6aA?e=YmOQXZ
thank you very much for your help
Hi @Bohumil_Uhrin ,
You can use the following measure, and it will show what you want:
Amortisation value prev =
VAR prev_month = MAX(data[Month])-1
RETURN
calculate([Amortisation value],filter(ALLEXCEPT(data,data[Material]),data[Month]=prev_month))
If this post help, please consider accept it as the solution to help other member find it more quickly.
Best Regards,
Dedmon Dai
thank you, this worked well 🙂
hi, yes, I was using measure for [max month], but with the variable its the same - Im geting blank values
is [max month] a measure? Use a variable instead.
User | Count |
---|---|
83 | |
77 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |