Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I've create a new table using SUMMARIZE and I need to combine this new table with another one (the column names are the same) but I can't see new tables in the editor.
Thanks
Solved! Go to Solution.
Hi @Luca2020 ,
The tables what you create using DAX expression are not shown in Query Editor in Power BI. They are just visible in front-end of the Power BI tool.
Query Editor (back-end) just shows the source data and any tables created within Query editor.
What you can do is create this summarised table in Query Editor using GROUP BY functionality. Then use it to merge to the relevant table.
Thanks,
Pragati
Hi @Luca2020 ,
The tables what you create using DAX expression are not shown in Query Editor in Power BI. They are just visible in front-end of the Power BI tool.
Query Editor (back-end) just shows the source data and any tables created within Query editor.
What you can do is create this summarised table in Query Editor using GROUP BY functionality. Then use it to merge to the relevant table.
Thanks,
Pragati
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |