Time intelligence involves analyzing data with a focus on time-related factors. Comparing data from different time periods is an important aspect of time intelligence. “Like-for-like” comparisons involve comparing similar or identical time periods. Standard time intelligence functions do not always make “like-for-like” comparisons possible, so advanced logic and techniques may be necessary to achieve this. In this tutorial, Sam will demonstrate how you can find the weekday and weekend day numbers within months using DAX.
Enterprise DNA Forum Post – https://bit.ly/3Hc2wPk
*****Video Details*****
00:00 Introduction
01:16 Comparing like-for-like
01:59 Why time intelligence calculations won’t work
02:52 Weekday number
03:42 Using RANKX
04:40 Day of month
05:56 Weekend number
***** Related Links *****
RANKX Considerations – https://youtu.be/W5lzIJ4qY7M
Advanced RANKX – https://youtu.be/afTb3qPV32E
A Deep Dive Into RANKX – https://youtu.be/GmuUdDRIyfU
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #RANKX