Forum Discussion

Sofiane85's avatar
Sofiane85
Frequent Visitor
3 years ago
Solved

sum culumns without duplicate

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's avatar
    Jihwan_Kim
    3 years ago

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

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

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