Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Calculating Last Date 's Price

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...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    erhan_79 ,

    Try like

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

th approach is different for either

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
6 years ago

you are right , i did not mention it Anonymous 

 

i want last price based on last date