How to use the lookup capability in Power Query

[Bluedbw]

I am compiling a summary of monthly sales reports which include a part number that has several embedded logic references. How to i incorporate another table file that has the logic references defines so that i can import them into the power query and then still be able to add a calculated column into the pivot table that is fed from the power query summary of many monthly sales registers. I think there is a way to connect the reports and define relationship as in a data model but not sure how to do that when utilizing the power query features

 

[Matt Allington]

Power pivot and power query are a whole new world; completely different approach to Excel. There is a lot to learn.

I suggest you take a look at these two articles I wrote some time back to get started, then come back with any questions

The Optimal Shape for Power BI Data

It is common for self taught Power Pivot users to get the shape of their data all wrong. This article describes the optimal way to do it.

exceleratorbi.com.au

Shaping vs Modelling in Power BI

Level: Beginners The objective of this article is to help you understand the differences between shaping your data (using Power Query) and modelling your data (using the modelling tools inside Power BI). You will need to do both to build a robust Power BI report. I first wrote this article...

exceleratorbi.com.au

Edit: make that 3 articles

Calculated Columns vs Measures in DAX

This article looks at Calculated PowerPivot Columns vs Measure ✅ PowerPivot expert, Matt Allington, explains the No.1 mistake he sees in self taught DAX students with an Excel background is the over use of PowerPivot Calculated Columns instead of Measures. This is an excellent article with...

exceleratorbi.com.au