Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I'm using Power BI Desktop and I was wondering if there is a way to create a calculated column based on different columns from different tables without the need to create a new table grouping the tables in question.
The calculated column will serve as a flag to compare the different columns.
Thanks,
Sabine O.
Solved! Go to Solution.
@SabineOussi As long as there exists a relationship between columns of different tables in your model, you can try using RELATED() function of DAX to achieve the same.
@SabineOussi As long as there exists a relationship between columns of different tables in your model, you can try using RELATED() function of DAX to achieve the same.
| User | Count |
|---|---|
| 60 | |
| 46 | |
| 32 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 82 | |
| 68 | |
| 43 | |
| 26 | |
| 25 |