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
JWE's avatar
JWE
Helper I
9 years ago

Hi Yuliana

thanks for help.

When I use your DAX (syntax see below) I get the result in picture 1.

Only when I select the items in the slicer (picture 2) I get the correct result.

It should also work without the selection - is it possible?

 


Yuliana =
DATEDIFF (
    CALCULATE (
        MIN ( 'Lagerbeleg'[Start DatumUhrzeit] );
        ALLEXCEPT ( 'Kreditor'; 'Kreditor'[KreditorNr] )
    );
    CALCULATE (
        MAX ( 'Lagerbeleg'[Ende DatumUhrzeit] );
        ALLEXCEPT ( 'Kreditor'; 'Kreditor'[KreditorNr] )
    );
    SECOND)
    / 60