{"id":15734,"date":"2023-07-10T13:01:28","date_gmt":"2023-07-10T13:01:28","guid":{"rendered":"https:\/\/stage.cloudthat.com\/training\/?post_type=stm-courses&#038;p=15734"},"modified":"2025-03-19T08:11:17","modified_gmt":"2025-03-19T08:11:17","slug":"advanced-dax-for-power-bi","status":"publish","type":"stm-courses","link":"https:\/\/stage.cloudthat.com\/training\/power-platform\/advanced-dax-for-power-bi","title":{"rendered":"Advanced DAX for Power BI"},"content":{"rendered":"<p>An advanced DAX course typically covers a wide range of topics, including time-intelligence functions, advanced filtering techniques, custom aggregation functions, optimization techniques, and working with advanced data modeling techniques such as bidirectional relationships, virtual tables, and hierarchies. The course may also include hands-on exercises and <a href=\"https:\/\/www.cloudthat.com\/resources\/blog\/mastering-power-bi-best-practices-for-dax-implementation\">Case Studies<\/a> to help participants apply their learning to real-world scenarios. The following are the major topics in the course:<\/p>\n<ul>\n<li><strong>Time intelligence:<\/strong> Time intelligence is crucial to data analysis, especially when dealing with business data. The training will explore advanced DAX techniques for time-related calculations, such as calculating year-to-date, comparing periods, and working with custom date hierarchies.<\/li>\n<li><strong>Complex Data Modeling:<\/strong> Explore strategies to handle complex data models with multiple tables, including managing relationships, working with hierarchies, and implementing advanced data modeling techniques.<\/li>\n<li><strong>Advanced Filtering:<\/strong> Dive into advanced filtering techniques using DAX, including the use of CALCULATE, CALCULATETABLE, and other functions to create dynamic and context-aware calculations.<\/li>\n<li><strong>Advanced Visualization Techniques:<\/strong> Learn how to leverage advanced DAX calculations to create visually impactful and interactive Power BI visualizations and reports.<\/li>\n<\/ul>\n<p>You&#8217;ll learn advanced data modeling techniques using DAX, including working with complex relationships, handling many-to-many relationships, implementing role-playing dimensions, and optimizing data models for improved performance.<\/p>\n<p>Overall, an advanced DAX course helps to improve their data analysis and modeling skills and use DAX more effectively for complex calculations and visualizations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An advanced DAX course typically covers a wide range of topics, including time-intelligence functions, advanced filtering techniques, custom aggregation functions, optimization techniques, and working with advanced data modeling techniques such as bidirectional relationships, virtual tables, and hierarchies. The course may also include hands-on exercises and Case Studies to help participants apply their learning to real-world [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":12638,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[121],"metadata":{"permalink_customizer_regenerate_status":["1"],"stm_lms_product_id":["15758"],"_edit_last":["2"],"_wp_page_template":["default"],"apss_content_flag":["0"],"lsq_tracking":["a:2:{s:8:\"tracking\";s:0:\"\";s:5:\"score\";s:0:\"\";}"],"_yoast_wpseo_content_score":["90"],"_yoast_wpseo_estimated-reading-time-minutes":["2"],"duration":[""],"_duration":["field_5fa0f3f0c86eb"],"day_1":[""],"_day_1":["field_5fce082f42f1e"],"time":[""],"_time":["field_5fce084742f1f"],"day_2":[""],"_day_2":["field_5fce085142f20"],"time_2":[""],"_time_2":["field_5fce089942f21"],"day_3":[""],"_day_3":["field_5fce08df42f22"],"time_3":[""],"_time_3":["field_5fce08f842f23"],"banner_image":["12472"],"_banner_image":["field_621873548f922"],"banner_description":["An advanced DAX (Data Analysis Expressions) course is a training program to help individuals improve their skills in using DAX for advanced data modeling, analysis, and visualization. DAX is a formula language used in Microsoft Excel, Power BI, and other data analysis tools for creating custom calculations and queries."],"_banner_description":["field_612c733ed3564"],"after_completing_course":[""],"_after_completing_course":["field_6103aae828228"],"key_features_0_lists":["Advanced DAX course will cover a wide range of advanced DAX functions and formulas, allowing you to manipulate and analyze data in more sophisticated ways."],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["This may include functions like CALCULATE, CALCULATETABLE, FILTER, SUMMARIZE, ALL, TOPN, and many others. Our certified instructors bring expertise and industry experience to DAX."],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["The training will likely include real-world use cases and examples to demonstrate how advanced DAX techniques can be applied to solve complex data analysis problems. This will help you understand how to leverage DAX effectively in practical scenarios."],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["To reinforce your learning, the course may include hands-on exercises and projects where you can apply the concepts you've learned. This will allow you to practice building advanced DAX calculations and data models."],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features":["4"],"_key_features":["field_6103aaff28229"],"who_should_attend_0_attend_lists":["The advanced DAX (Data Analysis Expressions) course is designed for individuals who have a basic understanding of DAX and want to take their skills to the next level. This course is ideal for:"],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"who_should_attend":["6"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_text":["<ul><li>Understanding of Basic DAX syntax: Participants should be familiar with basic DAX functions and operators, including CALCULATE, FILTER, and SUMX. <\/li>\r\n\r\n<li> Understanding of Data modelling: Participants should have experience with data modelling concepts, such as relationships between tables and creating calculated columns and measures. <\/li>\r\n\r\n<li> Power BI or Excel: Participants should be familiar with either Power BI or Excel, as these tools are commonly used in conjunction with DAX.<\/li><\/ul>"],"_prerequisites_text":["field_612c7498c4b84"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":[""],"_certification_0_list_content":["field_6103ab4a2822d"],"certification_0_image":[""],"_certification_0_image":["field_6103ab5b2822e"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":["21744"],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"course_section_0_module_title":["Introduction to DAX Language"],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section":["1"],"_course_section_0_section":["field_612f51e6b0277"],"course_section":["8"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":["a:4:{i:0;s:4:\"9550\";i:1;s:4:\"4595\";i:2;s:4:\"1408\";i:3;s:5:\"10337\";}"],"_related_courses":["field_61c453ca6b2dd"],"scorm_package":[""],"curriculum":[""],"shareware":[""],"featured":["on"],"views":["4583"],"level":["expert"],"current_students":["0"],"duration_info":["3 Days"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["24900"],"sale_price":[""],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"Who is this course designed for?\",\"answer\":\"This course is designed for Power BI users and professionals who are already familiar with the basics of DAX and want to take their skills to the next level.\"},{\"question\":\"What prerequisites are required to enrol in this course?\",\"answer\":\"Participants should have a solid understanding of the fundamentals of Power BI and be comfortable working with DAX formulas and functions.\"},{\"question\":\"What topics will be covered in this course?\",\"answer\":\"This course will cover advanced DAX techniques and concepts, including advanced calculations, time intelligence, handling complex data models, working with multiple tables, advanced filtering, optimization, and performance tuning. Participants will also learn best practices for efficient data modeling and analysis.\"},{\"question\":\"Will this course provide hands-on exercises?\",\"answer\":\"This course will include hands-on exercises and examples to reinforce the concepts discussed. Candidates can practice and apply the advanced DAX techniques in real-world scenarios.\"},{\"question\":\"What resources and materials will be provided?\",\"answer\":\"Participants will have access to course materials, including code samples, and exercises. Any necessary datasets and Power BI files required for the exercises will also be provided.\"},{\"question\":\"Can I apply the skills learned in this course to other data analysis tools?\",\"answer\":\"While this course focuses on using advanced DAX techniques in Power BI, many of the concepts and principles covered can be applied to other data analysis tools that support DAX, such as Excel Power Pivot and Analysis Services Tabular models.\"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"preview":[""],"lesson_excerpt":[""],"lesson_video_poster":[""],"lesson_video_url":[""],"lesson_video":[""],"lesson_files_pack":[""],"stream_start_date":[""],"stream_start_time":[""],"stream_end_date":[""],"stream_end_time":[""],"timezone":[""],"stm_password":[""],"join_before_host":[""],"option_host_video":[""],"option_participants_video":[""],"option_mute_participants":[""],"option_enforce_login":[""],"questions":[""],"quiz_style":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_waiting_room":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"assignment_tries":[""],"assignment_files":[""],"editor_comment":[""],"try_num":[""],"start_time":[""],"assignment_id":[""],"student_id":[""],"course_id":[""],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["121"],"custom_permalink":["microsoftdynamics\/pl-500-microsoft-power-automate-rpa-developer\/"],"_thumbnail_id":["12638"],"_yoast_wpseo_canonical":["https:\/\/stage.cloudthat.com\/training\/power-platform\/advanced-dax-for-power-bi"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["2488"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["3.5"],"_average_review_count":["field_62b00367d2de6"],"course_mark_average":["0"],"course_marks":["a:0:{}"],"_edit_lock":["1742371921:2"],"_wpb_vc_js_status":["false"],"_yoast_wpseo_wordproof_timestamp":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"question_view_type":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"sale_price_dates_start":[""],"sale_price_dates_end":[""],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"overview_section_heading":["Advanced DAX for Power BI-Course Overview"],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":[""],"_after_completing_course_heading":["field_645c78ade3f50"],"key_features_heading":["Key Features"],"_key_features_heading":["field_645388ceffdd1"],"who_should_attend_heading":["Who can participate in the Advance DAX Course?"],"_who_should_attend_heading":["field_645388faffdd2"],"prerequisites_heading":["What are the prerequisites for the Advanced DAX course?"],"_prerequisites_heading":["field_64538a51ffdd3"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["What makes the CloudThat a compelling for Advance DAX Course?"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list":["5"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"certification_heading":[""],"_certification_heading":["field_64538bffffdd5"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"course_outline_heading":["Course Outline"],"_course_outline_heading":["field_64538a8effdd4"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"faq_heading":[""],"_faq_heading":["field_64538c59ffdd8"],"wpdocs-meta-bdt":["24902"],"wpdocs-meta-gbp":["1399"],"wpdocs-meta-usd":["1601"],"who_should_attend_1_attend_lists":["Business analysts: Those who work with data regularly and want to improve their analytical skills."],"_who_should_attend_1_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_2_attend_lists":["Data analysts: Those who want to learn how to use DAX to create complex calculations and analyze data more effectively."],"_who_should_attend_2_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_3_attend_lists":["Power BI developers: Those who want to create more complex models and calculations in Power BI."],"_who_should_attend_3_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_4_attend_lists":["Excel users: Those who use Excel for data analysis and want to learn how to use DAX to create more complex formulas and calculations."],"_who_should_attend_4_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_5_attend_lists":["Overall, the advanced DAX course is best suited for individuals who have experience working with data and are looking to expand their skill set in this area."],"_who_should_attend_5_attend_lists":["field_6103adfb3f3e4"],"course_features_0_features_list_0_list":["With over 12 years of experience in training and consulting, we at CloudThat bring extensive expertise to deliver training based on the client\u2019s requirements and PL-300 training for Microsoft Power BI Data Analysts."],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["CloudThat has successfully trained a vast number of professionals, approximately 6.5 lakh individuals, and provided training services to more than 100 corporate clients across the globe."],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["Our Microsoft certificated trainers(MCTs) for the Advance DAX course emphasize significant hands-on experience to foster a learning approach around scenario-based problem-solving."],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list_3_list":["CloudThat offers training and consulting services with a proven track record of successfully delivering numerous projects, including engagements with Fortune 500 companies."],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_0_features_list_4_list":["CloudThat has established itself as a Microsoft Partner, as well as partnering with other renowned industry leaders such as AWS, GCP, and VMWare"],"_course_features_0_features_list_4_list":["field_644a0fc80e680"],"course_features_1_heading":["Learning Objectives of Advanced DAX:"],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list_0_list":["Mastery of Advanced DAX Functions: Gain a comprehensive understanding of advanced DAX functions and their usage, including complex functions like CALCULATE, CALCULATETABLE, FILTER, SUMMARIZE, ALL, TOPN, RANKX, and many others. Learn how to leverage these functions effectively to manipulate and analyze data."],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["Advanced Time Intelligence: Develop expertise in handling time-related calculations and analysis using DAX. Understand advanced techniques for calculating year-to-date, comparing periods, handling multiple calendars or fiscal years, and creating custom date hierarchies for more sophisticated time-based analysis."],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Advanced-Data Modeling Techniques: Learn advanced data modeling concepts and techniques to design efficient and flexible data models. Explore topics such as managing complex relationships, resolving many-to-many relationships, implementing role-playing dimensions, and optimizing data models for improved performance."],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Advanced Calculation Scenarios: Dive into advanced calculation scenarios that go beyond basic aggregation. Learn how to create dynamic measures, handle conditional logic, work with hierarchical data structures, and implement advanced calculations for complex business requirements."],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list":["4"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"course_section_0_section_0_title":[""],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["Different types of DAX data types"],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["Working with calculated columns and calculated measures"],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["Understanding the DAX engine, Vertipaq Engine"],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_3_lession_title":["Best Practices to start DAX."],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["4"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_module_title":["Understand the DAX Functions and categories of DAX functions:"],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":["Aggregation functions:"],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Working with aggregation functions such as: \u2022\tCount \u2022\tSum \u2022\tAverage \u2022\tMinimum, or Maximum"],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["1"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section_1_title":["Table functions:"],"_course_section_1_section_1_title":["field_612f5233b0278"],"course_section_1_section_1_lesson_list_0_lession_title":["Intro to table functions"],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_1_lession_title":["Filtering a table with Filter functions and ignoring filters"],"_course_section_1_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_2_lession_title":["Working with ALLSELECTED and RELATEDTABLE functions"],"_course_section_1_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_3_lession_title":["Tables and Relationships"],"_course_section_1_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_4_lession_title":["Using Table Variables for the complex requirements"],"_course_section_1_section_1_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list":["5"],"_course_section_1_section_1_lesson_list":["field_612f530a0ac40"],"course_section_1_section_2_title":["Iterator functions:"],"_course_section_1_section_2_title":["field_612f5233b0278"],"course_section_1_section_2_lesson_list_0_lession_title":["Introduction to Iterator functions"],"_course_section_1_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list_1_lession_title":["Working with Iterator functions like MINX and MAXX"],"_course_section_1_section_2_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list_2_lession_title":["Useful Iterators to work with tables and measures."],"_course_section_1_section_2_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list_3_lession_title":["Understanding the functions like ISINSCOPE and RANKX"],"_course_section_1_section_2_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list":["4"],"_course_section_1_section_2_lesson_list":["field_612f530a0ac40"],"course_section_1_section_3_title":["Time Intelligence Functions:"],"_course_section_1_section_3_title":["field_612f5233b0278"],"course_section_1_section_3_lesson_list_0_lession_title":["Introduction to Time Intelligence functions"],"_course_section_1_section_3_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_3_lesson_list_1_lession_title":["What are different time intelligence functions, common usage of those functions."],"_course_section_1_section_3_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_3_lesson_list_2_lession_title":["Working with functions like DATEADD, DATESINPERIOD"],"_course_section_1_section_3_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_3_lesson_list_3_lession_title":["Understanding the concepts of Running totals, Semi-Additive measures."],"_course_section_1_section_3_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_3_lesson_list":["4"],"_course_section_1_section_3_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["4"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Evaluation Context:"],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":[""],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Introduction to Evaluation Context"],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["Working with Evaluation context on Filtered context, Row Context, and Context Errors."],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Evaluation context and their relationships"],"_course_section_2_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["3"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["1"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["The Calculate Function:"],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":[""],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["Introduction to CALCULATE function."],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Using filter context inside the calculate function."],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["Understanding the KEEPFILTER context inside the Calculate function."],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_3_lession_title":["Advanced evaluation context using DAX."],"_course_section_3_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_4_lession_title":[" USERELATIONSHIP function usage in CALCULATE function to work with inactive relationships."],"_course_section_3_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_5_lession_title":["Using ALL function for filter context inside the CALCULATE function."],"_course_section_3_section_0_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_6_lession_title":["Using the ALLSELECTED function for filter context inside the CALCULATE function."],"_course_section_3_section_0_lesson_list_6_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_7_lession_title":["Using the KEEPFILTERS function for filter context inside the CALCULATE function."],"_course_section_3_section_0_lesson_list_7_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_8_lession_title":["Understand the concept of circular dependency."],"_course_section_3_section_0_lesson_list_8_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["9"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["1"],"_course_section_3_section":["field_612f51e6b0277"],"course_section_4_module_title":["Hierarchies in DAX:"],"_course_section_4_module_title":["field_612f5535940c3"],"course_section_4_module_description":[""],"_course_section_4_module_description":["field_612f564c921af"],"course_section_4_section_0_title":[""],"_course_section_4_section_0_title":["field_612f5233b0278"],"course_section_4_section_0_lesson_list_0_lession_title":["Introduction to Hierarchies"],"_course_section_4_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_1_lession_title":["Understand the concept of Parent-Child Hierarchies"],"_course_section_4_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_2_lession_title":["Working with FILTER and CROSSFILTER"],"_course_section_4_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list":["3"],"_course_section_4_section_0_lesson_list":["field_612f530a0ac40"],"course_section_4_section":["1"],"_course_section_4_section":["field_612f51e6b0277"],"course_section_5_module_title":["Querying:"],"_course_section_5_module_title":["field_612f5535940c3"],"course_section_5_module_description":[""],"_course_section_5_module_description":["field_612f564c921af"],"course_section_5_section_0_title":[""],"_course_section_5_section_0_title":["field_612f5233b0278"],"course_section_5_section_0_lesson_list_0_lession_title":["Introduction to Querying in DAX"],"_course_section_5_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_1_lession_title":["Working with tables and Queries"],"_course_section_5_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_2_lession_title":["Working with functions for querying like EVALUATE, CALCULATETABE, SELECTCOLUMNS, SUMMARIZE, CROSSJOIN, TOPN and GENERATE, ROW and DATETABLE."],"_course_section_5_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_3_lession_title":["Understanding the querying with measures UNION, INTERSECT, and EXCEPT"],"_course_section_5_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list":["4"],"_course_section_5_section_0_lesson_list":["field_612f530a0ac40"],"course_section_5_section":["1"],"_course_section_5_section":["field_612f51e6b0277"],"course_section_6_module_title":["Many-to-Many Relationship:"],"_course_section_6_module_title":["field_612f5535940c3"],"course_section_6_module_description":[""],"_course_section_6_module_description":["field_612f564c921af"],"course_section_6_section_0_title":[""],"_course_section_6_section_0_title":["field_612f5233b0278"],"course_section_6_section_0_lesson_list_0_lession_title":["Understand the Ambiguity of Many-to-Many relationships in Power BI."],"_course_section_6_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_1_lession_title":["How to handle many-to-many relationships"],"_course_section_6_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_2_lession_title":["Bidirectional Filtering in the modelling and work with them."],"_course_section_6_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list":["3"],"_course_section_6_section_0_lesson_list":["field_612f530a0ac40"],"course_section_6_section":["1"],"_course_section_6_section":["field_612f51e6b0277"],"course_section_7_module_title":["Relationships at different granularities:"],"_course_section_7_module_title":["field_612f5535940c3"],"course_section_7_module_description":[""],"_course_section_7_module_description":["field_612f564c921af"],"course_section_7_section_0_title":[""],"_course_section_7_section_0_title":["field_612f5233b0278"],"course_section_7_section_0_lesson_list_0_lession_title":["Working with data at different granularity"],"_course_section_7_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_1_lession_title":["Using TREATAS"],"_course_section_7_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_2_lession_title":["Working with Calculate Tables and slice dimensions."],"_course_section_7_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list_3_lession_title":["Leveraging the Week relationships"],"_course_section_7_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_7_section_0_lesson_list":["4"],"_course_section_7_section_0_lesson_list":["field_612f530a0ac40"],"course_section_7_section":["1"],"_course_section_7_section":["field_612f51e6b0277"],"_yoast_wpseo_title":["Advanced DAX Techniques for Power BI - CloudThat"],"_yoast_wpseo_metadesc":["Enhance your Power BI reports and dashboards with advanced DAX and gain the expertise to make data-driven decisions with confidence."],"permalink_customizer":["power-platform\/advanced-dax-for-power-bi"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"_regular_price_wmcp":["{\"USD\":\"1601\",\"GBP\":\"1399\",\"BDT\":\"24902\"}"]},"acf":[],"_links":{"self":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/15734"}],"collection":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses"}],"about":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/types\/stm-courses"}],"author":[{"embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/users\/13"}],"version-history":[{"count":0,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/15734\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/12638"}],"wp:attachment":[{"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=15734"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/stage.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=15734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}