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.
I have a calculated table created by DAX.
I want to convert it to a normal table.
How should I do?
Hello.
Well it is best in this case to create your calculated table using power query and not dax than you will be able to create your join
Did i answer your question? If yes do not forget to mark my answer as a solution!
Thanks, that was a great clue. I looked up how to create date tables in power query and it worked.
Hello great to hear that pls do not forget to like and mark my answers as a solution
I have a similar question. I have a calculated table as follows:
I think you'll find that calculated tables become "normal" tables the moment you create them. If by calculated table you mean tables created using the "new table" function. (they are only loaded "once" - ie every time you open a report: in other words, they are not "dynamic").
They are however "dynamic" in the context of measures in the sense that they are affected by filter context etc..But there again, in measures the tables are created "virtually".
Why are you asking btw?
Proud to be a Super User!
Paul on Linkedin.
Thank you.
I ask this question because I can't add a new Meausure based on the columns in a calculated table. An error: The value for 'XXX' cannot be determined. Either 'XXX' doesn't exist, or there is no current row for a column named 'XXX'.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |