topic Re: IF value is x then a and if value is y then b in DAX Commands and Tips

IF value is x then a and if value is y then b

einrikr — Mon, 24 Feb 2020 14:45:14 GMT

Hi all,

I think I'm massively overcomplicating my problem but as I'm quite new to DAX, I'd love to learn what I'm doing wrong.

I want to do something presumably extremely basic, but can't fathom how to do it...

My report has a column with 2 possible values: audit, or regulatory. Based on these values, I want to retreive values in other columns. If the value is 'audit', I want to retreive the deadline for testing purposes, stored in column 'validation deadline audit'.

If the valuw is 'regulatory', I want to retreive the deadline in column 'validation deadline regulatory'.

It seems pretty simple to do but I don't get what I'm supposed to be using. Can anyone of you help please?

Re: IF value is x then a and if value is y then b

Anonymous — Mon, 24 Feb 2020 14:47:53 GMT

Show the data model. We need to know how your tables are linked.

Best
D

Re: IF value is x then a and if value is y then b

Anonymous — Mon, 24 Feb 2020 14:51:19 GMT

Hi einrikr ,

I am going to assume that you want to evaluate everything on the same row. I would create a new calculated column.

Deadline = if([ColumnNameAuditorRegulatory]="Audit",[valididation deadline audit],[validatation deadline regulatory])

-Paul

Re: IF value is x then a and if value is y then b

einrikr — Mon, 24 Feb 2020 14:59:36 GMT

Thanks for your reply Anonymous darlove, see below.

It's all in one table, but somehow I still don't get what I should do...

Re: IF value is x then a and if value is y then b

Anonymous — Mon, 24 Feb 2020 15:08:41 GMT

einrikr

If it's all in one table, you can definitely use my formula above.

Re: IF value is x then a and if value is y then b

einrikr — Mon, 24 Feb 2020 15:27:42 GMT

It certainly did, thank you very much!

I expected that I would have to specify 'if value is x, then a or and if value is y, then b' but that's not the case 🙂

Re: IF value is x then a and if value is y then b

Anonymous — Mon, 24 Feb 2020 16:05:41 GMT

Awesome. Glad it worked. But yes, the format for if statements are if(evaluation, result if true, result if false).

If you're using a switch function (for handling multiple ifs, then you'd have to specify the various values)...

switch([values],"Audit",[auditdatecolumn],"Value2",[value2datecolumn],"Value3",[value3datecolumn],"Alternate Value")