Forum Discussion
zhivaninz
Helper I
4 years agoSUMMARIZE and measure using calculated columns returning different results for durations
The use case is processing duration for applications. Historically I've used calculated columns, but I wanted to move into 2022 and transition to using measures. However, when I tested against a test...
- 4 years ago
As always, further testing solved it.
The issue was there being duplicate application numbers, with different tendered/decision dates
Filtering both approaches down to the first application meant they returned the same result.
I will leave the post up as others may have a similar issue
Summarize, duplicates, duration, calculated column, datediff
zhivaninz
Helper I
4 years agoAs always, further testing solved it.
The issue was there being duplicate application numbers, with different tendered/decision dates
Filtering both approaches down to the first application meant they returned the same result.
I will leave the post up as others may have a similar issue
Summarize, duplicates, duration, calculated column, datediff