An Excel data model that handles millions of rows and relationships, with DAX measures.
Try it with AIPower Pivot stores data in an in-memory model that holds far more than a worksheet's row limit, links multiple tables by relationships, and computes advanced metrics with the DAX formula language.
Data Analysis Expressions — the formula language for Power Pivot and Power BI measures.