Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"),
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |