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.
Tag: Power Query
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
M Query Extension for Visual Studio Code
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
Insight Quest 