Calculating based on Max Date

[NewbieJono]

Hello, i am looking to calculate the total volume by each date for the Max date of receipt only:

example below.

[123abc]

First you Identify the Max DateOfReceipt with below Dax:

MaxDateOfReceipt = MAX('Table'[DateOfReceipt])

Then to Calculate Total Volume for Each Date (filtered by Max DateOfReceipt):

TotalVolumeForMaxDateOfReceipt =
CALCULATE(
SUM('Table'[Volume]),
'Table'[DateOfReceipt] = [MaxDateOfReceipt]
)

his will give you the result similar to the example in your screenshot, where it shows total volumes only for the entries with the maximum DateOfReceipt. Let me know if you need further customization!

[danextian · Accepted solution]

Hi @NewbieJono 

Please try this:

Measure1 = 
VAR MaxDate =
    CALCULATE ( MAX ( 'Table'[Receipt date] ), ALL ( 'Table'[Receipt date] ) )
RETURN
    SUMX (
        VALUES ( 'Table'[Date] ),
        CALCULATE (
            SUM ( 'Table'[Randvalues] ),
            FILTER ( 'Table', 'Table'[Receipt date] = MaxDate )
        )
    )

[shafiz_p]

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

[FreemanZ]

hi @NewbieJono ,

Try to plot a visual with date column and a measure like:

measure =

VAR _maxdatereceipt=MAX(data[DateofReceipt])

VAR _result=

SUMX(

    FILTER(

        data,

        data[DateofReceipt] = _maxdatereceipt

    ),

    data[volumn]

)

RETURN _result

[mh2587]

Total Volume for Max Receipt Date = //try this one
VAR MaxReceiptDate = MAX('TableName'[ReceiptDate])
RETURN
    CALCULATE(
        SUM('TableName'[Volume]),
        'TableName'[ReceiptDate] = MaxReceiptDate
    )