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.
Analyze SQL Server Query Store with Power BI
SQL Server and Power BI Collaboration Earlier this week at PASS Summit 2017, Erin Stellato, Principal Consultant with SQL Skills, delivered a pre-conference session regarding SQL
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.
Power BI Project Example
Good morning, Power BI Developer Let’s say you’re a BI developer within a corporate BI team and you’ve been assigned to a Power BI project.
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
Insight Quest 