Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone!
My question is simple: what I'd like to do is merging two tables (that I've imported from a SQL Server) by a calculated column that I've created in each table.
When I go on the query editor, and I click on the Query Merge, I can select the tables I want to merge, the kind of Join I want and the Columns I want to use to perform the join, but I cannot see the Calculated Columns that I created.
I wonder if I can overcome this problem in Power BI Desktop, I'd prefer avoiding to create a custom table on the SQL Server.
Do I have (if possible) to manually modify the query?
Many thanks to anyone who can help me!
Solved! Go to Solution.
To do this, you must calculate the column in your Query Editor, and not in DAX. Personally, for reasons like this, I've been using DAX almost exclusively to only create Measures.
If you post what your DAX does, I might be able to show you how to do that in M or with the Query Editor's GUI instead. If you do this, you'll be able to use the Query Editor's merge functionality on that column.
To do this, you must calculate the column in your Query Editor, and not in DAX. Personally, for reasons like this, I've been using DAX almost exclusively to only create Measures.
If you post what your DAX does, I might be able to show you how to do that in M or with the Query Editor's GUI instead. If you do this, you'll be able to use the Query Editor's merge functionality on that column.
Hi,
I recently came into this problem myself and I tried creating the column in the Query Editor instead as you suggested. My data has several million rows howevre and when I try to created the column in Query Editor, it seems to be taking a very very long time - so long that I just cancelled out of it.
Am I doing this incorrectly or that is just how it works due to it being in query editor and the large amount of data?
Thanks
Hi
I saw your anwer and I have the same issue. I was wondering if you could help me. This is what I crated in DAX
I have the same problem. I want to create a Calc Column in the Query Editor using a RELATED to another table. How can I solve that problem?
Ah, now I understand, thanks!
It seems not to be too much difficult, I'm gonna try on my own! Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |