SUMX On DateDiff?

DAX DAX Calculations
4

Hello @marek.regulski,

Thank You for providing the working PBIX file.

Well I just wrote one more small formula in order to have the grand totals. Below is the formula provided for the reference -

Days Change Previous Report - Harsh = 
SUMX(
    SUMMARIZE(
        Pbi , 
        Pbi[Project No.] , 
        Pbi[Job Site] , 
        Pbi[Source.Name] , 
        Pbi[End Date (Ops)] ) , 
    [Days Change Previous Report]
)

Resultant Output
Resultant Output916×454 20.8 KB

I’m also providing a link below where one of our expert @Greg had put up a great post about “How To Fix The Totals”.

As well as also attaching the working of my PBIX file for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Pbi_dset - Harsh.pbix (85.3 KB)

1 Like