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.
Hey,
I tried to sum up some values out of the previous month, like this:
It is just an example for me, so I can practise DAX and learn it - but it doesnt work at all and I have absolutely no clue why It's not working.
Can you please give me some hints?
Thanks,
Jnis
Solved! Go to Solution.
Hi @Jnis,
You should create the measure with your formula, then you will get the right output.
Measure =
CALCULATE ( SUM ( 'Table'[Gesamt] ), PREVIOUSMONTH ( 'Table'[Period] ) )
For reference, you could have a good look at of this blog Understanding calculated column and Measures.
Best Regards,
Cherry
Hi @Jnis,
You should create the measure with your formula, then you will get the right output.
Measure =
CALCULATE ( SUM ( 'Table'[Gesamt] ), PREVIOUSMONTH ( 'Table'[Period] ) )
For reference, you could have a good look at of this blog Understanding calculated column and Measures.
Best Regards,
Cherry
Hello,
You can try:
Calc=CALCULATE(SUM(...),PREVIOUSYEAR(...),ALL('Tabelle1'[Periode])
Generally in such cases it is recommended to have separate DateTables to relate to.
Your formula should then work perfectly as measure instead of calculated column.
The structure of your Table isn't ideal for PowerPivot. You should check out Unpivot.
Additionally: Here are two links for starters.
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 |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |