Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

Sum where date = another date

i wish to sum a volume where the dates in a coloumn equals a certain date (Calculated from another measure)   This does not seem to work   Oldest Date Volume = VAR Volume = CALCULATE( SUM(...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    NewbieJono , Try like

    Oldest Date Volume =

    VAR Volume =
    CALCULATE(
    SUM(DATA[Volume]),
    filter(DATA, [Oldest Date] = DATA[Date of Receipt])
    )

    Return
    Volume

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

amitchandak's avatar
amitchandak
Super User
4 years ago

NewbieJono , Try like

Oldest Date Volume =

VAR Volume =
CALCULATE(
SUM(DATA[Volume]),
filter(DATA, [Oldest Date] = DATA[Date of Receipt])
)

Return
Volume

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.