need formula help

[erhan_79]

Hi there ;

i need your help about below formula ,

i have Table A , it shows  the list prices of Material A and Material  B based son some dates.As you see list prices changing based on days.İ would like to create a new table which will list the latest price of materials .You can see with an example what i need.

Thanks in advance for your kind supports

[Anonymous · Accepted solution]

Hi  @erhan_79 ,

According to your description, I created some data to show:

Here are the steps you can follow：

1. Create a calculated table.

Table 2 =
FILTER('Table',
[Date]=
CALCULATE(
    MAX('Table'[Date]),
    FILTER('Table','Table'[Material]=EARLIER('Table'[Material]))))

2. Result.

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manikumar34]

@erhan_79 , 

You really don't reuire DAX here. 

Use lates date on the table. Refere to below screenshot. 

Regards, 

Manikumar

[erhan_79]

@manikumar34 , when you use latest section yes it is listing latest date but per  material system summarazing all amount.

i need uniq and specific one amount for considering day 

[ryan_mayu]

@erhan_79 

please try this

Table 2 = 
VAR TBL=SUMMARIZE('Table','Table'[Material],"Date",max('Table'[Date]))
RETURN ADDCOLUMNS(TBL,"Price",MAXX(FILTER('Table','Table'[Material]=EARLIER('Table'[Material])&&[Date]=EARLIER([Date])),'Table'[Price]),"Currency",MAXX(FILTER('Table','Table'[Material]=EARLIER('Table'[Material])&&[Date]=EARLIER([Date])),'Table'[Currency]))

[erhan_79]

dear @ryan_mayu ;

in your formula  system considering last day but , considering first day's price