Forum Discussion
Trouble with IF statement
Hi all, Fairly new to Power BI and DAX so I was hoping someone might be able to help me out here. I'm currently trying to create an IF statement using a field and it's not co-operating. The field...
Hi Anonymous ,
My test table:
Please try below steps:
1.Create a measure
Measure = VAR cur_jobtitle = MAX ( 'Rate'[JobTitle] ) VAR cur_payrate = MAX ( 'Rate'[Pay_Rate] ) RETURN IF ( cur_jobtitle = "Accounts Payable" && cur_payrate <= 45, 15.79, 15.00 )2.Visualize data with table visual
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
My test table:
Please try below steps:
1.Create a measure
Measure =
VAR cur_jobtitle =
MAX ( 'Rate'[JobTitle] )
VAR cur_payrate =
MAX ( 'Rate'[Pay_Rate] )
RETURN
IF ( cur_jobtitle = "Accounts Payable" && cur_payrate <= 45, 15.79, 15.00 )2.Visualize data with table visual
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.