Multiply 2 columns from 2 different tables in PowerBI using DAX | MiTutorials

Multiply 2 columns from 2 different tables in PowerBI using DAX | MiTutorials
PowerBI Tutorial for beginners

[vinirzd]

Thank you so much! This short tip helped me a lot.

[Vukiiketic]

Good one:) Clear and to the point:) Thanks!

[radzpage]

Hi. Thanks for this tutorial. I was able to solve my problem to check the total number of office 365 e3 licenses n table 2 base on the user login in table 1. Again thank you so much.

[FantasyLapse]

Does this work in many to many relationship tables?

[jasoncramer]

How would you do date differences between two tables? For instance, one table has date of incident and another has date of birth and I would like to determine how old the person was at the date of incident.

Thank you!

[DiscoverTalent]

Hi need help I have 100, 2000, 4000 values in one table and want to multiplywith 1, 2, 3, descending order later on want the after multiply values sum to divide by the total sum of 100, 2000, 4000 how can we. Do this ?

[kaushikdwivedi]

what if i want to create calculated column insisted of measure i tried this sumx(sales, sales[quantity]*RELATED(products[price]))
Problem: getting one value in all cells
note: i have one to many relations between Product and sales
to be consider my filter flow from product to sales

[sgb]

How to do it for direct connection table which contains quantity with an imported table which contains price

[vdweghp]

Hello and thanks for this video.

Could you however expand on the following : what if there is NO relation, and hence no join possible, between the two tables.

For instance, your Quantity table becomes a list of people and their salary.
Your second table contains a list of percentages.
Let's say 5, 6 .... 10%
When choosing one of those six percentage values, you want to recalculate the salary with that choise.
So the question is, how do I force Power BI, in the background,
to repeat my choice of percentage over all the people.
Once that is done, I can continue with the calculation ...

[saiprasad]

How to find the same i.e., quantity * price when there is no relationship between both tables. if possible can you post the dax formula for the requirement. thanks in advance.

[nessy]

When i tried to use this query in dimension table it's working, but when i used this in fact table it's not working why???

[manuelfischer]

How do i make things work, when my two tables are related by the dates table?
- I have 3 tables: ExpectedCost, ActualCost and Dates .
- each row of the cost tables has one specific date. There is no direct association between the tables.
- bouth cost tables are associated with the dates table.
=> I want to calculate and visualise the difference between the expected and actual cost by year.