sum culumns without duplicate

[Sofiane85]

Good morning All,

i'm new with DAX, please i need you help,

i have a table of products as you can see in this image:

i need to calculate the sum of the two columns (Quantite * Price) but only the last creation date for each product, because every creation date : the quantite and rice change.

please help me,

thank you

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, or how your desired outcome looks like, but please check the below picture and the attached pbix file.

expected outcome measure: =
VAR _latestdate =
    ADDCOLUMNS (
        DISTINCT ( Data[Product ID] ),
        "@latestdate", CALCULATE ( MAX ( Data[Creation Date] ) )
    )
RETURN
    CALCULATE (
        SUMX ( Data, Data[Quantity] * Data[Price] ),
        TREATAS ( _latestdate, Data[Product ID], Data[Creation Date] )
    )