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

     

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