Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have the following if statement
Missed Deadlines =
if('Maintenance Ticket System'[Status] = "Critical" & 'Maintenance Ticket System'[JobStarted]>1,"Missed",
if('Maintenance Ticket System'[Status] = "High" & 'Maintenance Ticket System'[JobStarted]>2,"Missed",
if('Maintenance Ticket System'[Status] = "Medium" & 'Maintenance Ticket System'[JobStarted]>3,"Missed",
if('Maintenance Ticket System'[Status] = "Low" & 'Maintenance Ticket System'[JobStarted]>5,"Missed",""))))
However I am getting the error
DAX comparison operations do not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Any help?
Solved! Go to Solution.
@Anonymous
Solved: DAX comparison operations do not support comparing... - Microsoft Power BI Community
You need to use double ampersand '&&' between your logical arguments. A single ampersand simply tries to concatenate text.
I'd also recommend using the SWITCH function in place of your nested IF statements as it makes the code easier to read.
Weekly Service Charge = SWITCH ( TRUE (), UnitCharge[ChargeFrequencyRef] = "M" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] * 12 / 52, UnitCharge[ChargeFrequencyRef] = "Q" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] * 4 / 52, UnitCharge[ChargeFrequencyRef] = "Y" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] / 52, UnitCharge[ChargeFrequencyRef] = "W" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] )
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
@Anonymous
Solved: DAX comparison operations do not support comparing... - Microsoft Power BI Community
You need to use double ampersand '&&' between your logical arguments. A single ampersand simply tries to concatenate text.
I'd also recommend using the SWITCH function in place of your nested IF statements as it makes the code easier to read.
Weekly Service Charge = SWITCH ( TRUE (), UnitCharge[ChargeFrequencyRef] = "M" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] * 12 / 52, UnitCharge[ChargeFrequencyRef] = "Q" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] * 4 / 52, UnitCharge[ChargeFrequencyRef] = "Y" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] / 52, UnitCharge[ChargeFrequencyRef] = "W" && DATESBETWEEN ( UnitCharge[StartDate], 01 / 04 / 2018, 01 / 04 / 2019 ) && UnitCharge[ChargeTypeId] = 2, UnitCharge[ChargeAmount] )
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
what is the new error ?
Same as the old one - it seems to not like the comparison having text and integer.
Even tried
Missed Deadlines =
SWITCH (
TRUE (),
'Maintenance Ticket System'[Status] = "Critical"
&& 'Maintenance Ticket System'[JobStarted]>1,"Missed",
'Maintenance Ticket System'[Status] = "High"
&& 'Maintenance Ticket System'[JobStarted]>2,"Missed",
'Maintenance Ticket System'[Status] = "Medium"
&& 'Maintenance Ticket System'[JobStarted]>3,"Missed",
'Maintenance Ticket System'[Status] = "Low"
&& 'Maintenance Ticket System'[JobStarted]>5,"Missed"
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |