Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
I explained what SCD means in a Business Intelligence solution in my previous post. We also discussed that while we do not expect to handle SCD2 in a Power BI implementation, we can handle scenarios similar to SCD1. In this post, I explain how to do so. Scenario We have a retail company selling products. … Continue reading Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
The post Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1 appeared first on BI Insight.
Published on:
Learn moreRelated posts
Power BI Update - June 2026
Power BI June 2026 Feature Summary
This month, we’re continuing to focus on making every day work a little easier—whether that’s building reports, modeling data, or just getting...
AI-Powered Power BI reporting: From design to deployment with agent skills (Preview)
AI powered Power BI reporting skills is a collection of multiple skills that enables AI agents to automate report creation, from designing pag...
Optimising DAX: VertiPaq Encoding Techniques
VertiPaq fits millions of rows in memory by compressing columns. Learn how value, hash and run-length encoding work, and what they mean for mo...
Building in the Agentic Era with Power BI and Fabric
Microsoft Build 2026 marks a major shift in how developers build data experiences with AI agents. Today we're announcing two capabilities that...
Power BI at Microsoft Build 2026: The Agentic Era of analytics
Microsoft Build 2026 brings the next generation of intelligent analytics to Power BI—where agents do the building, apps deliver insights ...
DAX User-Defined Functions (Generally Available)
DAX user-defined functions are now production-ready based on community feedback and internal validation. Their adoption during preview shows t...
No Code Power BI: How to Use Claude and the Power BI Modeling MCP Server
What if you could build a complete Power BI semantic model — date table, time intelligence measures, relationships and all — without touching ...