Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am trying to calculate the 6 months cumulative movement of inventory. Data comes from multiple transaction tables and each line you see is a measure.
I am giving below some key measures which are coming into play:
Expected Receipts = calculate(max([DOK Receipts],([Open PO]+[Incoming Transit])))
Expected Dispatches = calculate([Confirmed SO]+[Unconfirmed SO]+[Consignment TO],'Calendar'[Horizon]="Current Month")+CALCULATE(max([Forecast],([Confirmed SO]+[Unconfirmed SO]+[Consignment TO])),'Calendar'[Horizon]<>"Current Month")
Expected Consumption = calculate([OPS TO],'Calendar'[Horizon]="Current Month")+CALCULATE(max([OPS Consumption (Plan)],[OPS TO]),'Calendar'[Horizon]<>"Current Month")
Movement = [Expected Receipts]-[Expected Dispatches]-[Expected Consumption]
Cumulative Movement = calculate([Movement], FILTER(ALLSELECTED('Calendar'), 'Calendar'[Date]<=MAX('Calendar'[Date])))
Upto calculation of Movement per month, everything is fine. Cumulative Movement goes well upto first 2 months but then the problem begins. So far I could dignose that there is a certain pattern:
Can someone tell me what I am doing wrong?
Hi @vishal_maverick,
Could you please provide some sample data used in your measures and let me know how you build relationships for them if you still have problems on it? Thanks in advance!
Best Regards,
Community Support Team _ Caiyun
Thanks for the response. the problem is i am dealing with loads of transactional data and multiple relationships between the tables. I am unable to share the data.
Considering all measures are working out well until calculation of monthly movement, i dont see a problem in those measures. It is only the final one.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |