Forum Discussion
Pricing help needed!
Hi all! I created a dataset from different sources, most of them tables in SQL I would like to create calculate the prices for my products through past sales comparable. In one table, I have...
amitchandak
Super User
Super UserTry creating this as a new column in stock table
New column in stock= averagex(filter(sales,Sales[ZIPCODE ]='stock'[ZIPCODE] && Sales[PRODUCTTYPE ]='stock'[PRODUCTTYPE]),Sales[Price(€)/surface(sqm)])
The other option is lookupvalue.
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
I created the new column, and gives me a circular dependende error:
sales[price/surface],Stock[column],sales[price/surface]