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 have posted the problem at an other forum too. Link is given below.
https://www.excelguru.ca/forums/show...7495#post47495
Bookmarks