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(DATA[Volume]),
    [Oldest Date] = DATA[Date of Receipt]
)

Return

Volume
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.

1 Reply

  • 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.