Forum Discussion
Continued ContributorHow to create an IF statement in Power BI for reporting
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)
Continued ContributorAh... that might be it... let me check. I didn't even think of that (or know to think of that, actually).
Microsoft EmployeeCould 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)
- heathernicole
JeffDuzak - this worked - for this field it worked perfectly and it's probably more appropriate to relate it to the customer table in this case. :)
Thanks so much! I'm trying to learn DAX as I go - but reports are needed faster than I can learn the syntax. :)