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.
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
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
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
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