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.<\/p>\n

Enterprise DNA Forum Post – https:\/\/bit.ly\/3Hc2wPk<\/a><\/p>\n

*****Video Details*****
\n00:00 Introduction
\n01:16 Comparing like-for-like
\n01:59 Why time intelligence calculations won\u2019t work
\n02:52 Weekday number
\n03:42 Using RANKX
\n04:40 Day of month
\n05:56 Weekend number<\/p>\n

***** Related Links *****
\nRANKX Considerations – https:\/\/youtu.be\/W5lzIJ4qY7M<\/a>
\nAdvanced RANKX – https:\/\/youtu.be\/afTb3qPV32E<\/a>
\nA Deep Dive Into RANKX – https:\/\/youtu.be\/GmuUdDRIyfU<\/a> <\/p>\n

***** Learning Power BI? *****
\nFREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co\/courses\/ultimate-beginners-guide-to-power-bi
\nFREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co\/courses\/ultimate-beginners-guide-to-dax
\nFREE – Power BI Resources – www.enterprisedna.co\/power-bi-resources
\nEnterprise DNA On-Demand – app.enterprisedna.co
\nEnterprise DNA Subscription – app.enterprisedna.co\/pricing
\nEnterprise DNA Events – www.enterprisedna.co\/events<\/p>\n

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #RANKX<\/p>\n","protected":false},"excerpt":{"rendered":"

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. […]<\/p>\n","protected":false},"author":3,"featured_media":5605,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[137],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2023\/04\/pD5FhVuxj1g.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1so","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5604"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=5604"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5604\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/5605"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=5604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=5604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=5604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}