Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@Anonymous
give some idea, instead of "Addmonths" what i can use there? I mean alternate DAX function.
this is the model view (Deals_Active) is my fact table here. Any Idea?
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |