Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have the two tables below and would like to create three slicers, Region,Year,Month;
But i do not have any way of creating a true relashionship between the two tables is this possible to do via dax?
Region | Year | Month | Target |
UK | 2018 | Jan | 212 |
EU | 2017 | Feb | 122 |
USA | 2016 | March | 12 |
Region | Year | Month | Rev |
UK | 2018 | Jan | 23322323 |
EU | 2017 | Feb | 32323 |
USA | 2016 | March | 232323 |
Thanks
Peter
Solved! Go to Solution.
Here's what you generally do. Just copy and paste your query for one of your tables. Remove all of the other columns other than the one that you are interested in, let's say "Year". Remove duplicates. Save as your Year table. Now, if a new year is added in the data, you will automatically get it in your Year table.
If you have some values in one table and some in another, then what you want to do is do as above and then repeat for your other table and then create an Append query to append them together and remove duplicate values. Now you have a dimension table that has all of the possible values in both of your tables.
I would recommend creating a Region table, Year table and Month table. Relate these tables to both of your tables. Use the common tables as the slicers.
Sounds like a plan!
Would it best to ref the tables if any new values every get updated? can you even do that?
And if you can how? 🙂
Thanks
Peter
Here's what you generally do. Just copy and paste your query for one of your tables. Remove all of the other columns other than the one that you are interested in, let's say "Year". Remove duplicates. Save as your Year table. Now, if a new year is added in the data, you will automatically get it in your Year table.
If you have some values in one table and some in another, then what you want to do is do as above and then repeat for your other table and then create an Append query to append them together and remove duplicate values. Now you have a dimension table that has all of the possible values in both of your tables.
Thank you that worked
Awesome, and we made it through the entire thread without any reference to girls or cups or anything...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |