Forum Discussion
Last record before slicer
I have a table with production calculating the cost of each production batch. Another table showing the sales price of said products. The visualization should show the average sales price, the aver...
amitchandak
Super User
Super UserGuiBrum , I am not able to figure out the logic you have for price in a month . But I would have created a calculated column to get the price in the sales table. preferably use date in place on the month
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])
Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])
You can add remove condition as per need
The month and year on the table are really examples, the actual information is Date.
The problem is that the date slicer is handling the sales date correctly, but it is not picking up the production cost if the material was made before the slicer cut off.