Forum Discussion

zhivaninz's avatar
zhivaninz
Icon for Helper I rankHelper I
4 years ago
Solved

SUMMARIZE 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...
  • zhivaninz's avatar
    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