Get Started with DAX in Power BI | Advanced DAX | EP11
🔥 Master DAX in Power BI with this 2-hour deep-dive! Learn Date Functions, Time Intelligence (MTD / YTD / QTD), Previous Year comparisons, PARALLELPERIOD, FILTER, USERELATIONSHIP, Variables (VAR), and Quick Measures — all with real hands-on demos.This is Episode 02 of Class 11 in Robin's Power BI Step-by-Step Tutorial Series. Whether you're building a Date Dimension table from scratch or writing complex Year-on-Year growth formulas, this video covers it all with clear explanations and live Power BI demos.
📌 What You'll Learn:
✅ CALENDAR & CALENDARAUTO — Build a complete Date Dimension table
✅ Date Functions — NOW, TODAY, UTCNOW, EDATE, EOMONTH, DATEDIFF
✅ Time Intelligence — TOTALMTD, TOTALYTD, TOTALQTD with real business scenarios
✅ Period Comparisons — Previous Month, Previous Year, SAMEPERIODLASTYEAR
✅ PARALLELPERIOD — Compare sales across multiple years
✅ Year-on-Year Growth % — Build a complete YoY formula from scratch
✅ FILTER, CROSSFILTER & USERELATIONSHIP — Advanced relationship control
✅ VAR (Variables) in DAX — Simplify complex measure logic
✅ Quick Measures & Copilot — Auto-generate DAX with AI assistance
🕐 Chapters:
0:00 Introduction & Episode Overview
1:13 Topics Covered in This Episode
2:00 CALENDAR Function – Create a Date Dimension Table
5:11 CALENDARAUTO Function
6:04 NOW & TODAY Functions
6:24 UTCNOW & UTCTODAY Functions
9:24 EDATE Function
11:03 EOMONTH Function
13:46 DATEDIFF Function
18:26 CALENDARAUTO Deep Dive
22:35 DAY, MONTH, YEAR Functions
26:48 Time Intelligence Overview & Setup
33:41 TOTALMTD – Month-to-Date
39:15 TOTALQTD – Quarter-to-Date
41:28 TOTALYTD – Year-to-Date
44:45 Previous Month Comparison
55:04 SAMEPERIODLASTYEAR
58:22 Previous MTD, QTD & YTD
1:07:13 PARALLELPERIOD Function
1:13:12 Year-on-Year Growth % Calculation
1:21:44 VAR – Variables in DAX
1:26:28 CROSSFILTER Function
1:33:05 FILTER Function
1:42:05 USERELATIONSHIP Function
1:49:20 CROSSFILTER vs FILTER vs USERELATIONSHIP
1:50:22 Quick Measures
1:54:34 Quick Measures with Copilot
1:58:27 Wrap Up
**************************************
👨💻 Host & Producer:
Follow my other channel for short content: @DigitalDhruvin
Follow me on Instagram: https://www.instagram.com/powerplatformguy/
👉 Join Premium Membership using this Link.
https://www.youtube.com/channel/UCV_fdCIEX3O_YnAPvg8CYmA/join
Looking for a Consultancy? Connect Here! https://powerplatformtrainings.com/contact/
Follow me on all social Media Handles: https://linktr.ee/dhruvin.shah
************************************************
***********************************************
Full Power BI - Beginner to Advanced Playlist Link: https://www.youtube.com/playlist?list=PLib8Q64STW-ugBauDBjLPIwfXy4NSZliS
Episode 01: https://youtu.be/lkdpqZRO7ns
Episode 02: https://youtu.be/t9JyAwkSOJs
Episode 03: https://youtu.be/Fpe0NPKZly0
Episode 04: https://youtu.be/m8NTu4J5H88
Episode 05: https://youtu.be/kEgae8o90gE
Episode 06: https://youtu.be/shImS6XZs9o
Episode 07: https://youtu.be/FkgLNvpEX9g
Episode 08.1: https://youtu.be/t2oilfxnBSs
Episode 08.2: https://youtu.be/m5GUayn4nK8
EP 09: https://youtu.be/6SEj7clAxMw
EP 10 : https://youtu.be/0IdDeO_Q-wc
EP 11: https://youtu.be/mMhV0jWNWzE
#PowerBI #DAX #PowerBITutorial #TimeIntelligence #DataAnalytics #BusinessIntelligence #MicrosoftPowerBI #DAXFormulas #DataVisualization #PowerBIForBeginners #LearnPowerBI #PowerBIClass #DAXFunctions #PowerBIReport #DataModeling #PowerBIDAX #YearOverYear #PowerBIMeasures #QuickMeasures #PowerBICopilot Receive SMS online on sms24.me
TubeReader video aggregator is a website that collects and organizes online videos from the YouTube source. Video aggregation is done for different purposes, and TubeReader take different approaches to achieve their purpose.
Our try to collect videos of high quality or interest for visitors to view; the collection may be made by editors or may be based on community votes.
Another method is to base the collection on those videos most viewed, either at the aggregator site or at various popular video hosting sites.
TubeReader site exists to allow users to collect their own sets of videos, for personal use as well as for browsing and viewing by others; TubeReader can develop online communities around video sharing.
Our site allow users to create a personalized video playlist, for personal use as well as for browsing and viewing by others.
@YouTubeReaderBot allows you to subscribe to Youtube channels.
By using @YouTubeReaderBot Bot you agree with YouTube Terms of Service.
Use the @YouTubeReaderBot telegram bot to be the first to be notified when new videos are released on your favorite channels.
Look for new videos or channels and share them with your friends.
You can start using our bot from this video, subscribe now to Get Started with DAX in Power BI | Advanced DAX | EP11
What is YouTube?
YouTube is a free video sharing website that makes it easy to watch online videos. You can even create and upload your own videos to share with others. Originally created in 2005, YouTube is now one of the most popular sites on the Web, with visitors watching around 6 billion hours of video every month.
