Relational Query Designer Power Pivot. The last thing that remains is to explain to Power Pivot the relationship between the raw data and the newly created linked table of groups. Click Home Get External Data From Database From Analysis Services or Power Pivot.
Open the Power Pivot window. Business Intelligence w Power Query DAX. I want to combine two fields.
In short with Power Query you get your data into Excel either in worksheets.
Power Query Power Pivot DAX. Select FactSales in the Select Tables and Views step. In the PivotTable Fields pane select the fields to add to the PivotTable. I want to combine two fields.