Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
1 year ago
Solved

Calculating based on Max Date

Hello, i am looking to calculate the total volume by each date for the Max date of receipt only:   example below.  
Need Help
shafiz_p's avatar
shafiz_p
Super User
1 year ago

Hi NewbieJono  Try this:

TotalVolume= 
VAR MaxDateOfReceipt = 
    CALCULATE(
        MAX('Table'[DateOfReceipt]),
        ALLEXCEPT('Table', 'Table'[Date])
    )
RETURN
    CALCULATE(
        SUM('Table'[Volume]),
        'Table'[DateOfReceipt] = MaxDateOfReceipt
    )

 

Output:

 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

 

Best Regards,
Shahariar Hafiz