Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I currently have 1 calculated column from 3 separate tables that I want to bring into a new table, but PBI isn't allowing me to reference calculated columns. All three tables are share unique department names and a department ID numbers. Each table also shares this calculated column and are the columns I want to bring to a new table. How do I bring this column from each table to a new one?
@Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
38 | |
21 |