Trusted by 220,000+ people worldwide.
Inactive relationships are needed to make this technique work. They make sure that you’re iterating through every staff member first, and then working through the filtered data. This method guarantees the correct staff count per date. An active relationship would’ve given the incorrect calculation. Multiple dates scenarios can be very confusing when you’re staring out in Power BI. With this tutorial, you’ll have a better understanding of how to use this technique in your own models.
CEO & Founder
- Sam is Enterprise DNA's CEO & Founder. He helps individuals and organizations develop data-driven cultures and create enterprise value by delivering business intelligence training and education on Microsoft’s Power BI platform
- He partners with business decision-makers and analysts across all industries and business functions.
What’s the difference between a free account and a paid plan?
Do I need to know anything about data science or data analytics to get started with Enterprise DNA?
How will I be charged?
Can I get an invoice for my company?
Are refunds available?
Will AI take over the world and make data skills worthless?
Budgeting in Power BI
Analyze seasonal budget trends in Power BI by utilizing variables to manipulate data and represent the relationships between data tables.
Using Power BI visual interactions allows you to showcase data in a way that’s both compelling and easy to digest.
Virtual Relationships using TREATAS
The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside your Power BI models.
Get full access to unparalleled
training & skill-building resources
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.Learn More
Training, tools, and guidance to unify and upskill the data analysts in your workplace.Learn More