Problem in Dax to create measure to find Previous date Latest Cost.

Ramzan

New member
Joined
Jun 30, 2020
Messages
4
Reaction score
0
Points
0
Excel Version(s)
2019
Dax measure to find previous day latest cost is working if all dates are selected in pivot table. But if all dates are not selected then previous day latest cost is not found although it exists in source data.
Help needed on it.
Result is needed in Column F in attachment. Desired result is shown in G Column in attachment.

I posted this problem at an other forum but still not solved. Link of that thread is given below.

https://www.excelforum.com/excel-ge...-cost-post5650672.html?highlight=#post5650672
 

Attachments

  • Previous Day Latest Cost Dax.xlsx
    316.2 KB · Views: 6

Ramzan

New member
Joined
Jun 30, 2020
Messages
4
Reaction score
0
Points
0
Excel Version(s)
2019
Hy Ed Kelly thank you very much for reply.
I could not understand. Please guide in detail or apply on attached file and attach the file with solution.
 
Top