Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Completed hold stage for the top three rows hasn't got a completion date populated yet and it's defaulted to 44798.00
All the rows under this dont have a completion date for complaint actionable and it's doing the same thing.
I want the DAX to give today's date if there is no completion date populated but only if the action EXISTS. I'm trying to get this to show the amount of time for each measure in days.
Here are the two measures:
Thanks in advance, Dan
Solved! Go to Solution.
Hi @Dan492813
Please try
Completed Holding stage age =
VAR startdate =
MAXX (
FILTER ( 'hgmcntac', hgmcntac[action_cd] = "C1001A" ),
hgmcntac[completed_dt]
)
VAR enddate =
MAXX (
FILTER ( 'hgmcntac', hgmcntac[action_cd] = "C1002" ),
COALESCE ( hgmcntac[completed_dt], TODAY () )
)
RETURN
ROUNDUP ( ( enddate - startdate ) * 1, 0 )
Hi @Dan492813
Please try
Completed Holding stage age =
VAR startdate =
MAXX (
FILTER ( 'hgmcntac', hgmcntac[action_cd] = "C1001A" ),
hgmcntac[completed_dt]
)
VAR enddate =
MAXX (
FILTER ( 'hgmcntac', hgmcntac[action_cd] = "C1002" ),
COALESCE ( hgmcntac[completed_dt], TODAY () )
)
RETURN
ROUNDUP ( ( enddate - startdate ) * 1, 0 )
You're a star. As always.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |