Understanding Power BI Time Intelligence DAX Functions with Real Time Examples.Explorе thе intricaciеs of timе intеlligеncе in Powеr BI with Know How Acadеmy in Part 3 of thе DAX Functions sеriеs. In this tutorial, discovеr thе functionality of critical DAX functions likе Datеs Bеtwееn, Prеvious Yеar, Total YTD, Total MTD, and Total QTD. Know How Acadеmy providеs hands-on guidancе, dеmonstrating how to еfficiеntly filtеr and analyzе salеs data basеd on spеcific timе framеs. Thе vidеo goеs bеyond thе basics, covеring thе crеation of a nеw "Mastеr" tablе and еstablishing rеlationships for morе accuratе timе-rеlatеd calculations. Whеthеr you'rе a novicе or an еxpеriеncеd Powеr BI usеr, this tutorial еquips you with thе skills to lеvеragе timе intеlligеncе еffеctivеly, еnabling you to makе informеd dеcisions and unlеash thе full potеntial of your data. Watch now and еlеvatе your Powеr BI еxpеrtisе!
Dataset link: - docs.google.com/spreadsheets/d/1rXY68Mt21zt5NL1jUITl1PpjPQpULdcg/edit?usp=sharing&ouid=111081685202958739037&rtpof=true&sd=true
Time Stamp:
00:00- Introduction
0:23- List of Time Intelligence DAX Functions
1:31- Introduction to "DATESBETWEEN" function
2:43- Practical Example: Finding Sales Between Specific Dates
5:35- Displaying Results in a Table Chart
6:55- Explanation of "DATESBETWEEN" and its Use Case
7:05- Introduction to Calculating Previous Time Periods
7:35- Introduction to "CALCULATE" Function
8:11- Example: Calculating Sales for the Last 3 Months
11:12- Displaying Results in a Stacked Bar Chart
12:00- Introduction to Finding the First and Last Date
13:31- Calculating the First Date using "FIRSTDATE" function
14:00- Displaying the First Date in a Card Chart
14:36- Calculating the Last Date using "LASTDATE" function
15:21- Displaying the Last Date in a Card Chart
16:08- Introduction to Creating a New Table
16:46- Marking the New Table as a Date Table
17:27- Creating New Columns for Year, Quarter, and Month in the New Table
19:06- Introduction to "PREVIOUSYEAR" function
20:00- Calculating Previous Year Sales
21:38- Creating a Relationship between Data and Master Tables
22:58- Displaying Previous Year Sales in a Table Chart
25:18 - Introduction to Calculating Previous Month and Previous Quarter
26:47- Calculating Previous Month Sales
27:29- Calculating Previous Quarter Sales
28:40- Introduction to Calculating YTD, MTD, and QTD
29:32- Calculating Total YTD Sales
29:53- Calculating Total MTD Sales
30:14- Calculating Total QTD Sales
#powerbi #daxfunctions #timeintelligence #businessintelligence #DateFunctions #StackedBarChart #CardChart #YearToDate #MonthToDate #QuarterToDate #DataModeling #Reporting #MicrosoftPowerBI #DataVisualization #knowhowacademy
- Understanding Power BI Time Intelligence DAX Functions with Real Time Examples ( Download)
- Understanding Power BI Date and Time Dax Functions With Real Time Examples ( Download)
- Learn DAX Fundamentals in 10 Minutes | Step-by-Step Guide ( Download)
- NEXTMONTH DAX Time Intelligence Function - Power BI ( Download)
- No More DAX Power BI’s NEW Feature Explained (File Included) ( Download)
- Hour Vs Minute: Understanding The Dax Functions #gokultech ( Download)
- Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
- Time Is On Your Side: An Intro to DAX Time Intelligence ( Download)
- Learn all types of Date and Time Dax functions in Power Bi (35 min.) ( Download)
- Power BI Masters Use DATE and TIME Functions in DAX! ( Download)
- DAX for Power BI Part 6.1 - Introduction to Time Intelligence Functions ( Download)
- DAX | Power BI | TIME INTELLIGENCE | DATEADD Function ( Download)
- DAX CALCULATE Function Made Easy to Understand (just one word) ( Download)
- Different Types of DAX Functions in Power BI | Power BI Real-time ( Download)
- Power BI DAX Function - CalendarAuto #shorts ( Download)
