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 Everyone
I m lookng for a DAX Formula (Measure):
2018w1 2018w2
Demand 1 0
Stock 6 2
PO 3 1
Total 4 5
Total= Stock - Demand - PO
Basically the first period is normal, but those onwards should sum up also the previous Total
Demand, stock and PO are in the same table, Period in another one
I have a slicer with all the Components , and the first Period (in the example above) is always changing (the first one in the source table is 2015w1)
Thanks
Hi @Cuscino,
For your requirement , you need to add a condition to check total level, then write a formula to calculate with your logic to replace original calculate result.
Please provide some sample data and measure formula to help us clarify your table structure and coding formula.
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
103 | |
77 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |