Hi Guys, I had this working in Tableau and trying to rewrite it in Power Bi (Dax)

[Lolu]

In Tableau I approached this IF statement below by creating a parameter for each item [More than a week], [Missed this week], [Second Warning] and [First Warning] all as parameter and carried out an IF statement.

In using Power BI I am not sure what the best apporach is and if an IF statement is still applicable.

How can i approach this pleas, any comments assistance would be much appreciated.

IF
[CountDown]  < [More than a week] then
'More than a week'

ELSEIF
[CountDown] < [Missed this week] THEN
'Missed this week'

ELSEIF
[CountDown] < [Second Warning] THEN
'Second Warning'

ELSEIF
[CountDown] < [First Warning] THEN
'First Warning'
ELSE
'No Warning'

END

Many Thanks

L

[v-jiascu-msft · Accepted solution]

@Lolu,

Hi L,

I hope your parameters are either whole number or decimal number. There is a latest function "what-if" may help.

Test =
IF (
    [CountDown] < [More than a week Value],
    "More than a week",
    IF (
        [CountDown] < [Missed this week Value],
        "Missed this week",
        IF (
            [CountDown] < [Second Warning Value],
            "Second Warning",
            IF ( [CountDown] < [First Warning Value], "First Warning", "No Warning" )
        )
    )
)

1. You can change these parameters dynamically.

2. Only three data types by now.

3. One table for one parameter.

Reference: https://www.youtube.com/watch?v=ND8U0yXroaQ&feature=youtu.be&t=1549

Best Regards!

Dale

[Greg_Deckler]

That is not the correct syntax for an if statement, IF statements in DAX look like:

IF([CountDown]  < [More than a week],
     'More than a week',
     IF([CountDown] < [Missed this week],
          'Missed this week',
          IF([CountDown] < [Second Warning],
               'Second Warning',
               IF([CountDown] < [First Warning],
                    'First Warning',
                    'No Warning'
               )
           )
      )
)

That being said, I would go with a SWITCH statement.

https://msdn.microsoft.com/en-us/library/gg492166.aspx

[Lolu]

Hi Smoupre,

is there any benefit having these items [More than a week], [Missed this week] etc as parameters in Power BI?

Also the if statement seems to be working, but what might be the advantage of a switch over if in this case.

Many Thanks

L

[Greg_Deckler]

Developer types always tell me that a switch statement is preferred over an if statement for purposes of readability, logic flow, etc.

https://stackoverflow.com/questions/449273/why-the-switch-statement-and-not-if-else

[Lolu]

Hi Smoupre,

is there any benefit having these items [More than a week], [Missed this week] etc as parameters in Power BI?

Also the if statement seems to be working, but what might be the advantage of a switch over if in this case.

Many Thanks

L