I have 2 tables (Orders,Sales) which both has common field OrderID,
i would like to Multiply Orders table Quatity field and Sales Table Amount field.
this Caliculated field i want to add in Sales table.
Can some one guide me Formulae,im new to DAX.
Go to Solution.
First you need to create a relatonship. Go to Modelling tab, Manage Relationships. Create new one and choose OrderID field.
Then you create a new column, and write something like this:
TotalSales = Sales[Amount]*RELATEDTABLE(Orders; Orders[Quantity])
Should work out, maybe even without a relatedtable thingy.
View solution in original post
it worked as below.
TotalSales = Sales[Amount]*RELATED(Orders[Quantity])
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.