Convert query command to DAX command

[Anonymous]

Hi,

I'm trying to convert these query command into DAX measure command. Thanks for your help 🙂

"Resolution delay", each if [Due Date]= null then 9999 else [Resolution date]-[Due Date] )

"Previous week due date", each if Date.IsInPreviousWeek([Due Date]) then "YES" else "NO"),

"Pending effort 5 days", each if [Worked md]>5 and [Worked md]<=10 and [Status] <> "Closed" then "YES" else "NO"),

"Delayed ticket", each if [Resolution delay 2] = 9999 then "No due date" else if [Resolution delay 2] = -9999 then "In progress" else if ([Resolution delay 2] > 0 and [Resolution delay 2] < 9999) then "YES" else "NO"),

[Anonymous]

@Anonymous @Jihwan_Kim  any tips?