pull cost of an ProductName between dates using power bi

[Rajesh_Konda]

Hi All,

I am new to Power BI and have requirment to pull cost of a product name by dates, how much it was increased/Decreased each day.

Ex : Reliance(Name) cost was 9.64 on 01/09/2023 and on 01/10/2023 cost was 10. Now i need to display cost difference as .36 cost  on 01/10/2023 date visual,similarly for other Names.

•  One visual should display how much cost increased for all Names and the other should display how much it decreased by dates.
• Other visual should display cost increased/decreased by Names.
• How many new Names added days wise.
• How many Names removed day wise.

Can any one please guide me how can i achieve this, and best visual to present the above. Thanks in advance.

[Rajesh_Konda]

Thanks for the response @amitchandak ,

When i try with above query getting an error as 

The MAX function only accepts a column reference as an argument.

Can you help me out please, Table[Price] here default cost from table is not popping up.     

[amitchandak]

@Rajesh_Konda , Try a measure like

calculate(lastnonblankvalue(Table[Date], Table[Price]), filter(allselected(Table) , Table[Name] = max(Table[Name]) && Table[Date] <= max(Table[Date])))