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

     

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
    )