How To Manage Multiple Date Calculations In Your Fact Tables - Advanced Power BI

Managing multiple dates in your fact tables in Power BI can sometimes be very confusing when starting out in Power BI.

The idea behind this tutorial is to explain the logic and techniques required to get this working correctly in Power BI.

You need to get the right relationships and then use the correct DAX formula patterns when managing multiple date calculations.

Enjoy

Sam

***** Video Details *****
1:52 - the formula and model
5:33 - understanding through visuals
6:33 - calculating active orders
10:59 - why inactive relationships are important

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-gu…
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-gu…
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-do…
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Online - enterprisedna.co/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
How To Work With Multiple Dates In Power BI - blog.enterprisedna.co/working-with-multiple-dat…
Master Virtual Tables In Power BI Using DAX - blog.enterprisedna.co/working-with-virtual-in-m…
Discover Multiple Product Purchases Using DAX In Power BI - blog.enterprisedna.co/discover-the-amount-of-cu…

***** Related Course Modules *****
Time Intelligence Calculations - portal.enterprisedna.co/p/time-intelligence-cal…
DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives
Ultimate Beginners Guide to DAX - portal.enterprisedna.co/p/ultimate-beginners-gu…

***** Related Support Forum Posts *****
How To Calculate Multiple Rows For A Condition - forum.enterprisedna.co/t/how-to-calculate-multi…
Filter By Multiple Dates In The Same Table - forum.enterprisedna.co/t/filter-by-multiple-dat…
One Dimension, Multiple Facts And Multiple Interconnected Facts - forum.enterprisedna.co/t/one-dimension-multiple…
For more multiple date calculations support queries to review see here…. - forum.enterprisedna.co/search?q=multiple%20date…