Calculate OPEN CASES over time in Power BI | Part 1

In this video I focus on calculating active items over time. This can be used when you only need to know the active employees, active subscriptions or open contracts.
You will learn how to create a measure in DAX and in turn calculate only active cases over time.
Enjoy!

Download file here https://datatraining.io/powerbi-how-to

--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...

Power BI Essentials https://datatraining.io/powerbilearni...

Business User Training https://datatraining.io/powerbi-busin...

For Custom Trainings and Consulting email directly [email protected]

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:28 Setting the base for the calculation
2:08 Calculating the number of active employees
5:38 Limiting the time frame
6:45 Using the calculation
07:18 End

---------------------------------
😍 JOIN 😍
----------------------------------
Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO​
Insta   / howtopowerbi  
LinkedIn   / basdohmen  
TikTok   / how.to.power.bi  
X   / howtopowerbi  
fb   / howtopowerbi  
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear https://amzn.to/47F21Yc
📚 Power BI books MUST READ! https://amzn.to/3tUfFcj
💡 General books I recommend https://amzn.to/48YNo33
🎶 Music for my videos https://www.epidemicsound.com/referra...
🚀 For growing on YouTube: https://www.tubebuddy.com/bas
🏄 Stuff I use daily https://amzn.to/3HqfMQ2

Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX