Excel Tips
Define Relationships Between Tables »
March 13, 2023
There are three different ways to define a relationship in Power Pivot. Say you want to link from the ProdID field in the Fact table to the ProdID field in the Products table. Follow these steps:
Use Joiner Tables Between Tables »
March 6, 2023
I have a top-level budget table with one row per month, region, product. It has 54 rows. I want to create a report comparing the budget table to an invoice table with hundreds of rows.
Reporting from the Smaller Side of the Relationship »
March 3, 2023
I am trying to report sales and quota. My sales table has hundreds of records. The Quota table has just one record per region. The pivot table created through the Data Model is not working.
Pivot from Multiple Tables Using The Data Model »
March 2, 2023
I have a lot of rows in a data table and then some lookup tables. Is there a faster way to create a report than building a bunch of VLOOKUP formulas?
Dive into M Code For More Power Query »
March 1, 2023
The Power Query interface provides an easy way for you to write steps in the M programming language. There are many things possible in M that can not be done in the interface.
Use Column From Examples to Learn Power Query Formulas »
February 28, 2023
I need to add a new column in Power Query. The formula syntax is difficult to learn.
Merge Columns in Power Query »
February 27, 2023
I have first name in column A and last name in column B. I would like to concatenate those names and convert to proper case.