Forum Discussion

cmfb's avatar
cmfb
Frequent Visitor
4 years ago
Solved

Cumulative measure based on multiplied values, changing when multiplier updates

Hello - I have a need to calculate the cumulative production $ value by item, which is the production output by month multiplied by the average item sales price for the month.  The issue is creating ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

cmfb , Make sure the month year in the table is coming from the calendar table and the join is single directional.

 

Try like

CALCULATE(
Sumx(SUMMARIZE('Item', 'Item'[Item No],
"Qty", [Production Quantity],
"Avg Price", [Average Item Price]), [Qty]*[Avg Price]),
FILTER(ALL('Calendar'),
'Calendar'[Date] <= max('Calendar'[Date]) )
)

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

  • cmfb's avatar
    cmfb
    Frequent Visitor
    4 years ago

    Thank you!  I've accepted this one as the solution as it works great, and still works with time intelligence (can filter for current year, etc.).