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

    erhan_79 ,

    Try like

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