Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How to convert a calculated table to a noraml table?

I have a calculated table created by DAX.

 

I want to convert it to a normal table.

 

How should I do?

6 REPLIES 6
CharbelArmaleh
Resolver II
Resolver II

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.

https://tinyurl.com/5n7wnzkf

Hello great to hear that pls do not forget to like and mark my answers as a solution

nsaraf
Frequent Visitor

I have a similar question. I have a calculated table as follows:

SampleDates = CALENDAR (DATE (2015, 1, 1), DATE (2015, 12, 31))
Now I need to merge this table with another table using an OUTER JOIN. In the other table the dates are not contiguous as in this calculated table. When I use Transform Data and try to create a Merge Query I do not see the calculated table listed. Instead only the tables I have linked from a data source are visible. What am I missing?
 
PaulDBrown
Community Champion
Community Champion

@Anonymous 

 

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?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

@PaulDBrown 

 

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'.

 

https://community.powerbi.com/t5/Desktop/Is-it-possible-to-create-a-new-Meausure-based-on-the-column... 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.