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
Date Key Column Conversion Date columns in source tables are often stored as integers in YYYYMMDD format. However, to take advantage of date intelligence features in
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
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 History Requirements A common requirement for fact tables and BI queries generally is to retrieve a specific date interval relative to the current date.
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