So, You’re Getting a Data Warehouse for Power BI…
Well, I’m no expert. I learned Power Pivot and Power BI through Excel. What I know is from helping to build a SQL data warehouse. That is, I’ve worked with a data warehouse pro.
Category: Relationships
AutoExist, Cross Table Filtering, and You
The autoexist logic magically removes combinations that don’t exist, but only for columns in the same table. Also, Cross Table Filtering…
DAX – Dynamic Age Calculation Using Measures
I was recently helping a forum member at https://powerpivotforum.com.au with a problem about how to dynamically calculate an employee’s age.