Need Help with Cumulative difference based on item#

Anonymous , not very clear what you mean by the above value. The logic does not fit in

We can create a measure like

Cumm balance= CALCULATE(SUM(Table[Released]),filter(date,date[date] <=max(Table[Date])))

- CALCULATE(SUM(Table[Required]),filter(date,date[date] <=max(Table[Date])))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.

AnonymousYour calculation seems to be little complicated to achieve but not impossible. I request you to share your excel file with the calculation, will then suggest appropriate solution to you. Thanks

Hi, Anonymous 

You may create a calculated column and a measure as below. The pbix is attached in the end.

FormattedMonthYear = VALUE(FORMAT(Sheet1[Month Year],"yyyymm"))
Qty Remaining = 
var _base =
CALCULATE(
    AVERAGE(Sheet1[Curr Released Inv Qty (Base qty)]),
    FILTER(
        ALL(Sheet1),
        Sheet1[Item #] = SELECTEDVALUE(Sheet1[Item #])
    )
)
var _required = 
CALCULATE(
    SUM(Sheet1[Required ( same as Total Fqty)]),
    FILTER(
        ALL(Sheet1),
        Sheet1[Item #] = SELECTEDVALUE(Sheet1[Item #])&&
        Sheet1[FormattedMonthYear]<=SELECTEDVALUE(Sheet1[FormattedMonthYear])
    )
)
return
_base-_required

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan