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 All,
I have an issue I could use some help with. I need to create a running total measure instead of the below.
Where that has +'s and -'s for each month, this data isn't really totaled up so that it makes sense looking in the future.
Where I have this:
Current Month:
Current Inventory: 10
Ins: 5
Outs: 6
Final Inventory : 9
Next Month:
Current Inventory: 0
Ins: 0
Outs: 7
Final Inventory : -7
I'd like this:
Current Month:
Current Inventory: 10
Ins: 5
Outs: 6
Final Inventory : 9
Next Month:
Current Inventory: 9
Ins: 0
Outs: 7
Final Inventory : 2
Thanks!
Solved! Go to Solution.
Try Like this . Adding Inventory from day one. I have used the same table. Use appropriate tables
Inventory till date = Var _min_date_for_inventory = CALCULATE(maxx(all('Date'[Date Filer]),'Date'[Date Filer])) Var _Todays_date=CALCULATE(maxx(ALLSELECTED('Date'[Date Filer]),'Date'[Date Filer])) Var _inventory= CALCULATE(sum(Sales[Sales Amount]),Sales[Sales Date]<=_min_date_for_inventory) Var Sale_till_tody =CALCULATE(sum(Sales[Sales Amount]),filter(sales,Sales[Sales Date]<=maxx(Sales,Sales[Sales Date].[Date]))) Var purchase_till_tody =CALCULATE(sum(Sales[Sales Amount]),filter(sales,Sales[Sales Date]<=maxx(Sales,Sales[Sales Date].[Date]))) return _inventory+Sale_till_tody-purchase_till_tody
Try Like this . Adding Inventory from day one. I have used the same table. Use appropriate tables
Inventory till date = Var _min_date_for_inventory = CALCULATE(maxx(all('Date'[Date Filer]),'Date'[Date Filer])) Var _Todays_date=CALCULATE(maxx(ALLSELECTED('Date'[Date Filer]),'Date'[Date Filer])) Var _inventory= CALCULATE(sum(Sales[Sales Amount]),Sales[Sales Date]<=_min_date_for_inventory) Var Sale_till_tody =CALCULATE(sum(Sales[Sales Amount]),filter(sales,Sales[Sales Date]<=maxx(Sales,Sales[Sales Date].[Date]))) Var purchase_till_tody =CALCULATE(sum(Sales[Sales Amount]),filter(sales,Sales[Sales Date]<=maxx(Sales,Sales[Sales Date].[Date]))) return _inventory+Sale_till_tody-purchase_till_tody
Hi,
Share the link from where i can download your PBI file.
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |