CASE STATEMENT TO DAX?
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