Forum Discussion
Created tables using DAx doesn't show in Power Query
You cannot. Power Query is a one way street - from source data to the data model. Objects like calculated tables and columns do not show up in Power Query. You have two options here.
- Create the calculated table in Power Query. You might need to use the Group By functionality on the transform ribbon, then add some custom columns. It depends what you need. Then do the merge.
- You cannot merge in DAX, but you can bring values from one table to another in calculated columns using the LOOKUPVALUE() function, which is similar to VLOOKUP in Excel.
#2 is not recommended. If it is a small model it won't matter, but if it is large, over 1M records, you will suffer from the lack of optimized compression calculated columns has. Your best bet is to always shape your data in Power Query or earlier, and leave the DAX model to just do analysis.
You cannot. Power Query is a one way street - from source data to the data model. Objects like calculated tables and columns do not show up in Power Query. You have two options here.
- Create the calculated table in Power Query. You might need to use the Group By functionality on the transform ribbon, then add some custom columns. It depends what you need. Then do the merge.
- You cannot merge in DAX, but you can bring values from one table to another in calculated columns using the LOOKUPVALUE() function, which is similar to VLOOKUP in Excel.
#2 is not recommended. If it is a small model it won't matter, but if it is large, over 1M records, you will suffer from the lack of optimized compression calculated columns has. Your best bet is to always shape your data in Power Query or earlier, and leave the DAX model to just do analysis.