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.
Hello,
I'm using Power BI for the first time and I stucked in running totals. I need to sum my forecast amount based on stock location (Store, Warehouse and Without Stock).
I want to show running totals of each articles and for Store & Warehouse Locations.
Item No | Stock Location | Forecast Amount | Expected Result |
8 | Store | 15 | 15 |
8 | Warehouse | 15 | 15 |
7 | Warehouse | 12 | 27 |
1 | Store | 10 | 37 |
1 | Warehouse | 10 | 37 |
5 | Store | 7 | 44 |
6 | Store | 6 | 50 |
2 | Without Stock | 5 | |
4 | Without Stock | 4 |
Also when I do it based on forecast amount it sums same article twice,
RunningTotal_S+WS = VAR GT = Sheet1[Forecast Amount] RETURN SUMX ( FILTER ( Sheet1; Sheet1[Forecast Amount]>= GT ); Sheet1[Forecast Amount])
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Running-Total-Through-Direct-Query/m-p/628353#M300215
Hello @v-chuncz-msft thank your your reply.
code in the link summarize forecast amount for all items based on min item no.
what I need is running total for forecast amount starting from max value based on stock locations of Store and Warehouse and once for each article. e.g item no "1" should be used once not twice.
Also could it be possible to have it as a column? As I understand measure and column formulas are different from each other.
regards
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |