Skip to content

Insight Quest

Brett Powell's Data & Analytics Blog

  • Home
  • Frontline Analytics
    • On-Site Training
    • BI Assessment
    • Corporate Site
  • Insight Quest
    • Tech Event Schedule
    • Boston BI User Group
    • Power BI User Group – Data Access
  • Resources
    • MSBI Books

Tag: M Query

Boston Code Camp M Query Materials

November 18, 2017 Brett Powell

Earlier today I presented M Query Fundamentals at Boston Code Camp 28. The following zip file contains the supporting PowerPoint slides from this session and

Continue reading

Date Key Conversion in Power BI

November 16, 2017 Brett Powell

Date Key Column Conversion Update: The February 2018 release of Power BI Desktop introduced the Mark as Date Table feature. This feature, which had been

Continue reading

Power BI Template Design

November 9, 2017 Brett Powell

Self-Service Power BI Report Template The final task for the dataset designer in sprint 12 is to create a report template (.PBIT file) that will

Continue reading

Integrated Product Dimension Query

November 2, 2017 Brett Powell

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.

Continue reading

Trailing Period M Queries

November 2, 2017 Brett Powell

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.

Continue reading

Dynamic Customer History Segmentation

October 19, 2017 Brett Powell

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

Continue reading

Blog Archive

Blog Topics

Tags

Analysis Services DAX Excel M MSBI Power BI Power BI Administration Power BI Desktop Power Pivot Power Query SSAS Tabular

Enter your email address to follow this blog and receive notifications of new posts by email.

Insight Quest

Blog Post History

January 2023
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Jun    

Five Popular Posts

  • Group Email Notification for Dataset Refresh Failure
    Group Email Notification for Dataset Refresh Failure
  • Power BI Report Server Monitoring
    Power BI Report Server Monitoring
  • Analyze SQL Agent Job History with Power BI
    Analyze SQL Agent Job History with Power BI
  • Paginated Report Execution Time
    Paginated Report Execution Time
  • XMLA-Based PBI Dataset Refresh Automation
    XMLA-Based PBI Dataset Refresh Automation

Top 10 Power BI Blog for 2019

Top 10 Power BI Blogs Badge

Microsoft Power BI Partner

Blog at WordPress.com.
  • Follow Following
    • Insight Quest
    • Join 340 other followers
    • Already have a WordPress.com account? Log in now.
    • Insight Quest
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...