sum culumns without duplicate

Sofiane85 — Wed, 23 Nov 2022 09:19:51 GMT

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

Re: sum culumns without duplicate

Jihwan_Kim — Wed, 23 Nov 2022 10:18:16 GMT

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

topic sum culumns without duplicate in DAX Commands and Tips

sum culumns without duplicate

Re: sum culumns without duplicate