Convert query command to DAX command

Anonymous — Thu, 10 Jun 2021 15:11:07 GMT

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"),

Re: Convert query command to DAX command

Anonymous — Thu, 10 Jun 2021 15:35:43 GMT

Anonymous Jihwan_Kim any tips?

topic Convert query command to DAX command in DAX Commands and Tips

Convert query command to DAX command

Re: Convert query command to DAX command