Filter Last Date with Multiple Values in Row

Question

Good morning Community.

I'm needing help performing the following filter

I have the following table, which is a pricing table, in which when I change prices in my ERP, it generates a column in the SQL table in which I put the product code, the update date and the new price.

For this example you can see that the price of the product was changed 3 times.

What I need is a Dax formula so that I can display only the value of the master code for the last update date.

Master Column = Product

Column "Last Date Product Date = Last Updated Date"

This example is filtered for 1 article, but in the table I have a lot of them with this case

Slds

anonymous · Accepted Answer

Hi&nbsp;Syndicate_Admin&nbsp;,Depending on the information you provided, I created a simple example to help you solve the problem. You can follow these steps below:
1.Add new column.
&nbsp;
Latest Update Date = 
CALCULATE(
    MAX('Table'[Update Date]),
    ALLEXCEPT('Table', 'Table'[Product Code])
)
&nbsp;
2.Add new measure.
&nbsp;
Latest Price = 
CALCULATE (
    SUM ( 'Table'[Price] ),
    FILTER ( 'Table', 'Table'[Update Date] = 'Table'[Latest Update Date] )
)

&nbsp;
Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
&nbsp;
Best Regards,
Ada Wang
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Filter Last Date with Multiple Values in Row

1 Reply

Related content

Filters with multiple value

Filter out multiple value

Waterfall with multiple values

Multiple Years Filter

COUNTROWS FILTER - Multiple Values