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.
Power BI Community,
I have a sample data such as below.
When a column "Sequence" is "Actual", I have actual data in rebate column.
When a column "Sequence" is "Forecast", I do not have rebate data.
What I would like to do is to create a measure with if function and calculate function combinations to calculate rebate when "Sequence" is "Forecast"
For instance, I would like to calculate rebate as
However, when I try if DAX it only recognizes a measure not a column value such as "Actual" or "Forecast"
Please find below as the sample data
Thank you for your support!
H
Solved! Go to Solution.
If you are writing a measure, regardless of whether you are using an IF statement, you have to wrap any column reference in an aggregator like SUM, COUNT, MAX, MIN, etc. And, you generally need to include the table name like 'Table'[Column]. So, something like SUM('Table'[Column]).
If you are writing a measure, regardless of whether you are using an IF statement, you have to wrap any column reference in an aggregator like SUM, COUNT, MAX, MIN, etc. And, you generally need to include the table name like 'Table'[Column]. So, something like SUM('Table'[Column]).
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |