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

Day: November 2, 2017

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

Analyze SQL Server Query Store with Power BI

November 2, 2017 Brett Powell

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

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

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

November 2017
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« Oct   Dec »

Five Popular Posts

  • Refresh Power BI Datasets with PowerShell
    Refresh Power BI Datasets with PowerShell
  • XMLA-Based PBI Dataset Refresh Automation
    XMLA-Based PBI Dataset Refresh Automation
  • Parameterize SSRS Reports with DAX Queries
    Parameterize SSRS Reports with DAX Queries
  • Conditional Formatting for Card Visuals
    Conditional Formatting for Card Visuals
  • Common Power BI Admin Scripts Part 1
    Common Power BI Admin Scripts Part 1

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