Forum Discussion
Solved
Show values between dates selection
Hi all, I have a report page which shows Item sales details. Now I want to map cost of the item on each line. The Cost table is like as follows: ItemNumber PostingDate UoM Cost 3002...
i did the data transform in PQ, pls see if this is what you want
you can create a measure
Measure =
VAR _date=max('date'[Date])
VAR _date2=maxx(FILTER('Table','Table'[PostingDate]<=_date),'Table'[PostingDate])
return maxx(FILTER('Table','Table'[PostingDate]=_date2),'Table'[Cost])
pls see the attachment below