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.
Hello everyone,
I created a Crossjoined table with a DAX formula, when I try to merge this table it doesn't appear as a possible merging option.
I would be updating one of the tables I used to create the crossjoined one, do you know if there is another way I can merge this two (crossjoine table and a excel database) besides the Merging Option from the Query Editor?
Thank you
Diego G.
Correct, because you created the table in DAX, Power Query doesn't know anything about that table. You will need to use something like NATURALINNERJOIN or NATURALLEFTOUTERJOIN functions, which can be a little challenging. I recommend @Phil_Seamark's insightful guidance and examples in his fantastic new book, Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence.
Thank you very much!
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |