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 |
|---|---|
| 55 | |
| 37 | |
| 23 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |