Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi, I'm new in here. Have searched previous posts to see if this question has been resolved elsewhere, but couldn't find anything.
I have built a table using DAX formulae, but it has become way to complicated. It will be much better to build the table in Query. Is there a way to build the new table and either switch all the existing reports to reference the new table, or overwrite the DAX table with the new Query table?
Thank you.
Hi @tuckstar
I don't quite understand what you mean, do you want to create a new table in Query and then overwrite the dax table? How do you want to be covered?
Calculated tables or columnd created with dax cannot be displayed in Power Query
Best Regards!
Yolo Zhu
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |