Calculating Last Date 's Price

[erhan_79]

Hi Dear Community ;

i need your kind help to create below formula ;

i have table A , which has agreement date per materials for prurchasing ,  and i want to create Table B , rule will be like that 

Table B will include only for per material last day's price and it's date as below , as you see i mentioned yelow remarked for table A that ones last day's price and on table B there are only this prices and their dates

Thanks in advance dear friends 

[Anonymous]

do you want last price or do you want max price?

th approach is different for either

[erhan_79]

you are right , i did not mention it @Anonymous 

i want last price based on last date 

[amitchandak · Accepted solution]

@erhan_79 ,

Try like

lastnonblankvalue(Table[Date],max(Table([price])))

[erhan_79]

thank you @amitchandak  but when itry your formula i got below error , what can be the reason 

also for reminding , i want last price based on last date not maximum one infact

[Greg_Deckler]

@erhan_79 - Not clear on whether you want this in a table table or Table visual but it seems like the basics of what you want can be handled by the Lookup Min/Max pattern: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

[erhan_79]

thank you dear @Greg_Deckler  , that one very useful info i will consider it