Forum Discussion
Solved
if then else
Most languages have a structure that allows multiple conditions to be met in an IF statement, like this: IF condition1 THEN result1 Else If condition2 THEN result2 ELSE result3. Except for DA...
Cool my dear friend.
We can do anything in DAX cool.
Try this,
Measure =
Switch ( True(),
condition1,"Result1" ,
condition1,"Result1" ,
etc... )
let me if any help in DAX.
Cool my dear friend.
We can do anything in DAX cool.
Try this,
Measure =
Switch ( True(),
condition1,"Result1" ,
condition1,"Result1" ,
etc... )
let me if any help in DAX.
I tried to use the above query but not excusted.
I wanted to split the condition into the three different statement.
- Avg time from purchase request[PR->DATE1] to Inquiry floated to supplier(active request)[TENDER->DATE3] (days)
- Avg time from {Inquiry floated to supplier}[TENDER->DATE3] to {Commercial approval done [TENDER->DATE10] (days)}
- Average time from Commercial approval done[TENDER->DATE10] to PO issue [PO->DATE4](days).
For this, I think we can use a case statement how we use in SQL