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 ContributorI actually tried both ways and got the same error message, oddly enough.
Microsoft EmployeeCould 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.
- heathernicole
Ah... that might be it... let me check. I didn't even think of that (or know to think of that, actually).
- JeffDuzak
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)
- 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. :)
HI , can someone please help me here ... Am writing the following but get syntax DAX error.
Recovered Value = if('Recoveries-Month wise breakup'[Status]= "Recovered" or "Posted" ,'Recoveries-Month wise breakup'[Amount],0)
Basically I want the recovered value when the status is recovered or posted .
PLease help .
- heathernicole
arpihm - Hello! :) It may be the 'or' part of the statement.
I don't think DAX likes that syntax. I'm still learning - but I have multiple custom fields that have more than criteria for the IF statements.
I'm pretty sure that's not the appropriate syntax.
Recovered Value = if('Recoveries-Month wise breakup'[Status]= "Recovered" or "Posted" ,'Recoveries-Month wise breakup'[Amount],0)For multiple criteria IF statements - I usually layer it, so to speak. See below. There may be a better way to do it, but this should work, depending on what the error is.
Recovered Value = IF ( 'Recoveries-Month wise breakup'[Status] = "Recovered", 'Recoveries-Month wise breakup'[Amount], IF ( 'Recoveries-Month wise breakup'[Status] = "Posted", 'Recoveries-Month wise breakup'[Amount], 0 ) )
