Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jnis
Frequent Visitor

DAX: Calculate Previous Month Sum, doesnt work

Hey,
I tried to sum up some values out of the previous month, like this:

 

Unbenannt.PNG

 

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

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

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] ) )

 

 

Capture.PNG

 

For reference, you could have a good look at of this blog Understanding calculated column and Measures.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

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] ) )

 

 

Capture.PNG

 

For reference, you could have a good look at of this blog Understanding calculated column and Measures.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Floriankx
Solution Sage
Solution Sage

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.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.