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
Hello, the product price is sales price (for each customer) so it is not calculated.
the batch cost is calculated within Power Query, the tables are available from power query (it has much more than only the columns I show - these seem to be the relevant columns).
I tried to be concise on the question. Here is my model