In today's video, we are going to go through how to think about Time Intelligence calculations with a specific case: Calculating the number of open orders using DAX.
I read a million years ago a blog post from Gerhard where he explained how to do it and even though we are not going to use the same DAX syntax or functions , we will use his methodology:
blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: curbal.com
Contact us: curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
- DAX Fridays #208: Open orders in DAX | Events in progress & Time intelligence ( Download)
- DAX and the Start Date End Date Problem aka Events In Progress ( Download)
- Power BI - Events in Progress Part 1 ( Download)
- DAX Fridays! #209: Allocation calculations in DAX | GENERATE ( Download)
- Calculate OPEN CASES over time in Power BI | Part 1 ( Download)
- Power BI - Events in Progress Snapshots ( Download)
- Events in Progress - displaying items present between two dates in Power BI / Excel with Power Query ( Download)
- Subscription Pattern in Power BI DAX Measure for Active Subscribers or Open Tickets For All Dates ( Download)
- Calculate OPEN CASES over time in Power BI | Part 2 ( Download)
- DAX Fridays! #210: Is the end of DAX coding near - Microsoft Build announcements for Power BI ( Download)
- DAX Fridays! #207: IF.EAGER | What are eager evaluations ( Download)
- Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX [2023 Update] ( Download)
- DAX measure with start AND end date for Power BI ( Download)
- BI DAX Time Intelligence - QTD -Quarter till date ( Download)
- DAX Fridays #203: Google's FAQ on DAX ( Download)
