Earlier today I presented M Query Fundamentals at Boston Code Camp 28. The following zip file contains the supporting PowerPoint slides from this session and
Tag: M Query
Date Key Conversion in Power BI
Date Key Column Conversion Update: The February 2018 release of Power BI Desktop introduced the Mark as Date Table feature. This feature, which had been
Power BI Template Design
Self-Service Power BI Report Template The final task for the dataset designer in sprint 12 is to create a report template (.PBIT file) that will
Integrated Product Dimension Query
Remaining Task: Revised Product Query In last week’s blog post, Brett’s top remaining work item for Sprint 12 was to revise the product dimension query.
Trailing Period M Queries
Trailing History Requirements A common requirement for fact tables and BI queries generally is to retrieve a specific date interval relative to the current date.
Dynamic Customer History Segmentation
The Situation: First Purchase Date Your customer dimension table has a column (attribute if you prefer) for the date of the first purchase for the