topic Multiple IF statements in DAX in DAX Commands and Tips

Multiple IF statements in DAX

JacksonMaui — Sat, 23 Apr 2022 16:15:09 GMT

Creating a new Column or Change original - I am trying to Divide a Value in a Column based on the Value's Name. I have multiple NAMEs and VALUEs to change. I am unable to add multiple IF statements. Also if the NAME is not defined how do I pass the original Value to the new column?

Column = IF('DSR'[Name]="CureTimeValue",[VALUE]/10)

Your help is much appreciated!

Re: Multiple IF statements in DAX

karnold — Sat, 23 Apr 2022 18:27:03 GMT

You could specify another IF() function in the ResultFalse (aka else) parameter. The last IF() would return the original value. See: IF – DAX Guide For example

Column = IF('DSR'[Name]="CureTimeValue",[VALUE]/10, IF('DSR'[Name]="SomethingelseValue",[VALUE]/15, [Value] ) )

Another, maybe better option is Switch() SWITCH – DAX Guide. Example:

Column = SWITCH('DSR'[Name], "CureTimeValue",[VALUE]/10, "SomethingelseValue",[Value]/15, [Value] )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Re: Multiple IF statements in DAX

tamerj1 — Sat, 23 Apr 2022 19:30:29 GMT

Hi JacksonMaui

best is to have all names vs the related value in a lookup (dimension) table. The easiest and most efficient way to proceed after that is to create a one to many relationship. The rest wiuld be a piece of cake.

Re: Multiple IF statements in DAX

JacksonMaui — Mon, 25 Apr 2022 12:46:18 GMT

karnold I was close, this was perfect solution. Thank you very much!