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
  • danextian's avatar
    danextian
    1 year ago

    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 )
        )
    )

     

5 Replies

  • mh2587's avatar
    mh2587
    Super User
    1 year ago
    Total Volume for Max Receipt Date = //try this one
VAR MaxReceiptDate = MAX('TableName'[ReceiptDate])
RETURN
    CALCULATE(
        SUM('TableName'[Volume]),
        'TableName'[ReceiptDate] = MaxReceiptDate
    )
  • FreemanZ's avatar
    FreemanZ
    Super User
    1 year ago

    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

  • 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

  • danextian's avatar
    danextian
    Super User
    1 year ago

    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 )
        )
    )

     

  • 123abc's avatar
    123abc
    Community Champion
    1 year ago

    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!