Handling Multiple Dates in Power BI With DAX

Enterprise DNA
Enterprise DNA
90.5 هزار بار بازدید - 7 سال پیش - Watch the 2022 Update of
Watch the 2022 Update of this video here: Handling Multiple Dates in Power BI W...

Learn how to work with multiple dates within an underlying fact table by using the USERELATIONSHIP function within CALCULATE

**** Video Details ****
0:13 - introduction
1:50 - natural filtering with the active relationship
3:38 - using USERELATIONSHIP function
5:10 - what confuses users when working with multiple dates
5:48 - conclusion

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
Show Results Up To Current Date Or A Specific Date In Power BI - https://blog.enterprisedna.co/2019/07...
Show Days Before Or After A Selected Date Using Power BI - https://blog.enterprisedna.co/2019/07...
The DATEADD Function: The Best And Most Versatile Time Intelligence Function in Power BI - https://blog.enterprisedna.co/2018/12...

**** Related Course Modules ****
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time...
Power BI Super Users Workshop - http://portal.enterprisedna.co/p/powe...
Advanced Data Transformations & Modeling - http://portal.enterprisedna.co/p/adva...

**** Related Support Forum Posts ****
Managing common metrics across multiple date tables - https://forum.enterprisedna.co/t/mana...
‘Role-Playing’ Multiple Date Dimensions to Index New Store Openings - https://forum.enterprisedna.co/t/role...
Want Totals For Multiple Dates not connected to Dates Table - https://forum.enterprisedna.co/t/want...
For more multiple dates support queries to review see here -
https://forum.enterprisedna.co/search...
7 سال پیش در تاریخ 1396/03/03 منتشر شده است.
90,529 بـار بازدید شده
... بیشتر