Forum Discussion
multiplication
hello power BI community I hope you are doing good. so I'm a beginner on power BI desktop ,and I'm working on a report and I've been struggling since a while to achieve it. I have different columns from different tables and I would like to add a new columns which contain a the result of the multiplication between two different columns , I tried many methods and none was right ;I always have an error message. I verified the relations too and i think they are correct. So there are the different columns and the relations between them ,they all have the same designation ,so i will be grateful if you explain for me how to do it !
2 Replies
your data model looks interesting. What's the reasoning behind it? What do you think is your "facts" table?
AYA97 , I see multiple inactive joins, looking at data screenshot data model is not very clear
Example how can you mode data across table
Item Name = RELATED('item'[Brand])
Copy City without using related
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])Using lookup
Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])
first and third expect a single value, so use some aggregation function if there are more than one value
