Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]).
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |