topic Re: CASE STATEMENT TO DAX? in DAX Commands and Tips

CASE STATEMENT TO DAX?

Anonymous — Wed, 04 Mar 2020 15:57:14 GMT

Hi Community,

I want to convert this CASE STATEMENT SQL Query to DAX?

SQL Query:

1. DayDiff(AddMonths(min(month),3),min(month)) AS tot_days, (Measure 1)

2. CASE WHEN daydiff(Now(),min(month)) > DayDiff(AddMonths(min(month),3),min(month)) THEN DayDiff(AddMonths(min(month),3),min(month)) ELSE daydiff(Now(),min(month)) end AS days_completed (Measure 2)

Is it possible?

Reg,

Dhana

Re: CASE STATEMENT TO DAX?

Anonymous — Wed, 04 Mar 2020 16:34:44 GMT

Everything is possible but without knowing anything about the tabular model, without knowing the tables and relationships involved... not much can be done in this case, I'm afraid.

Best
D

Re: CASE STATEMENT TO DAX?

Anonymous — Wed, 04 Mar 2020 16:54:03 GMT

this is the model view (Deals_Active) is my fact table here. Any Idea?

Re: CASE STATEMENT TO DAX?

Anonymous — Wed, 04 Mar 2020 16:57:19 GMT

Anonymous

give some idea, instead of "Addmonths" what i can use there? I mean alternate DAX function.

Re: CASE STATEMENT TO DAX?

Anonymous — Wed, 04 Mar 2020 16:58:43 GMT

https://dax.guide/dateadd/

Re: CASE STATEMENT TO DAX?

Anonymous — Wed, 04 Mar 2020 16:59:59 GMT

CASE in DAX translates into SWITCH.

https://dax.guide/switch/

Best
D