Forum Discussion

mattrixdesign2's avatar
mattrixdesign2
Helper I
3 years ago

Measure or Column for Last Price Paid

I have done some various searches on this, but I cant find answer or missunderstanding it.   I am looking to capture "LAST PRICE BILLED" (at customer / part level).   Example below - all for the ...
Need Help
sergej_og's avatar
sergej_og
Super User
3 years ago

Ok mattrixdesign2 ,
then try this out.
You should get (in best case) your target result for last billed price and latest invoice date - with little adjustments to your model.

 - Last price billed

 

Last price billed = 
 CALCULATE(
     LASTNONBLANKVALUE('Calendar'[Date] , SUM(your_table[unit price]) ),
        SUMMARIZE(
            your_table,
            your_table[Customer],
            your_table[Part No],
            "Date", MAX(your_table[Invoice Date])
            )
 )

 


 - MAX Invoice date

 

MAX Inv. Date = 
    MAX(yout_table[Invoice Date])

 

 
Hope it helps.

Regards
Sergej