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
About two weeks ago Version 1.0.0 of the Power Query M Language extension for Visual Studio code was released: Here’s a link to it in