Forum Discussion
Continued ContributorHow to create an IF statement in Power BI for reporting
Trying to create an 'IF' statement in DAX.
I'm trying to create a calculated column - if Age of Customer is <= 365 - then display 4000
if it's greater than 365 - display nothing - or 0.
This is what I've tried to use - New Customer Pts = IF(Customer[Age of Customer (in Days)] <= 365, 4000, 0)
But it gives me this error: A single value for column 'Age of Customer (in days)' in table 'Customer' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
It worked for another calculated column, so I'm not sure why it won't for this one. The concept seems the same to me...
Any help is greatly appreciated!
Thanks! :)
Could you double check that you are adding a calc column to the Customer table? If you are adding a calc column to a different table, then you won't be able to directly refer to a column on the Customer table.
Could you describe your model a bit more? Where do you want to define this calculated column?
If you want to define the column in a table that has a many-to-one or one-to-one relationship or path of such relationships to the Customer table, then you *can* refer to columns in the Customer table, but you just have to wrap the reference in a call to the RELATED function. So, it would look like:
New Customer Pts = IF(RELATED(Customer[Age of Customer (in Days)]) <= 365, 4000, 0)
8 Replies
- kcantor
Community Champion
Have you double checked to make sure you have selected to create a calculated column instead of a measure? It may be something simple as they do live close to each other on the ribbon. Honestly, I did that just today so I figured I would suggest the most simplistic solution first.
- heathernicole
I actually tried both ways and got the same error message, oddly enough.
JeffDuzakMicrosoft Employee
Could you double check that you are adding a calc column to the Customer table? If you are adding a calc column to a different table, then you won't be able to directly refer to a column on the Customer table.
