Forum Discussion
Implement CASE statement just like TSQL in PowerBI
Maybe I haven't understood but uou can use a simple if :
result = if AVG_USER_ACTIVE < 10 and PercentUsage < 20.00 and Total > 180 then 1 else 0
And you can nest them :
result = if 1=1 and 1<>2 then
if 1<2 then 1 else 0
else 0
Use parenthesis to priorize and clarify.
Jean-Pierre Riehl
Maybe I haven't understood but uou can use a simple if :
result = if AVG_USER_ACTIVE < 10 and PercentUsage < 20.00 and Total > 180 then 1 else 0
And you can nest them :
result = if 1=1 and 1<>2 then
if 1<2 then 1 else 0
else 0
Use parenthesis to priorize and clarify.
Jean-Pierre Riehl
Thanks ! I created a custom column with what you suggested and now its working.
Just a note for future readers: You cannot create a measure as I thought I could initially and hence this question.
You can create a Measure or a Calculated Column with that logic. You just need to write it in DAX.
In DAX, IF() is a function and logical operators are && (AND) and || (OR).
(there are also AND() / OR() functions but it is less readable)
Here is the syntax :
= IF([AVG_USER_ACTIVE] < 10 && [PercentUsage] < 20.00 && [Total] > 180 ; 1 ; 0)
Notice the brackets [] to reference a Column or another Measure.
You can nest IF() functions in second and third parameters
In DAX, you also have the SWITCH function if you want different results with different inputs.