Forum Discussion
DAX Measure
Hi, I have an Excel data Matrix JAN FEB MAR ARP MAY JUN JUL AUG SEPT OCT NOV DEC TOTAL Air 7 3 0 1 4 22 0 3.6 0 0 0 1 41.6 Water 2 6 1 0 0 5 0 2.1 3 0 ...
Hi Anonymous ,
Create a what if parameter and then use the metric that is created to make the multiplication.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
The new measure will be something similar to:
Adjusted Qty = SUM(Qyt) * [Parameter measure]
Hi Anonymous ,
Create a what if parameter and then use the metric that is created to make the multiplication.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
The new measure will be something similar to:
Adjusted Qty = SUM(Qyt) * [Parameter measure]