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.
Tag: M
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 Segments Sorted
Short Recap: Dynamic Customer History Segments In last week’s blog post, a Customer History Segment column was added to the M query for the Customer
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
Data Source Staging Queries
Parameterized Data Source Queries For Power BI datasets, a recommended data access method is to define parameters specific to the data sources and then develop
Power Query SDK for Visual Studio
The previous post regarding the M extension for Visual Studio Code failed to acknowledge another relatively new alternative we have for M queries: Power Query SDK