Forum Discussion

JWE's avatar
JWE
Helper I
9 years ago

Compare Rows and sum

Hi folks   I need help for this scenario. For 4 inbound deliveries (from the same vendor) I have 4 rows with date and time. When I calculate the time in minutes (Minuten je Beleg) and sum the col...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi JWE,

 

Please refer to below measure;

Sum Between Start and End =
DATEDIFF (
    CALCULATE (
        MIN ( 'Compare Rows and sum'[Start] ),
        ALLEXCEPT ( 'Compare Rows and sum', 'Compare Rows and sum'[KreditorNr] )
    ),
    CALCULATE (
        MAX ( 'Compare Rows and sum'[End] ),
        ALLEXCEPT ( 'Compare Rows and sum', 'Compare Rows and sum'[KreditorNr] )
    ),
    SECOND
)
    / 60

Result:

 

If I have something misunderstood, please correct me and describe your requirment more clearly.

 

Thanks,
Yuliana Gu