filmov
tv
DAX for Power BI Part 7.2 - Creating a Financial Year Calendar
Показать описание
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
This video shows you how to create a calendar table using DAX which includes a financial year, quarter and month column. You'll see how to calculate thes values using the AddColumns and Calendar tables, as well as how to use the calendar in measures with some of DAX's time intelligence functions.
Chapters
00:00 Topic list
00:49 The Data Model
02:17 The CalendarAuto Function
04:38 The Calendar Function
06:26 Using a Variable for the Start Month
08:39 Calculating the Start and End Year
12:59 Calculating Date Parts
14:55 Calculating the Financial Year
18:32 Calculating the Financial Month
20:52 Calculating the Financial Quarter
22:14 Using the Financial Year Calendar
25:36 Calculating Year to Date over Financial Years
27:12 The PreviousYear Function
28:48 DatesBetween, StartOfYear and EndOfYear Functions
30:21 Calculating the Percentage of Year Total
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
This video shows you how to create a calendar table using DAX which includes a financial year, quarter and month column. You'll see how to calculate thes values using the AddColumns and Calendar tables, as well as how to use the calendar in measures with some of DAX's time intelligence functions.
Chapters
00:00 Topic list
00:49 The Data Model
02:17 The CalendarAuto Function
04:38 The Calendar Function
06:26 Using a Variable for the Start Month
08:39 Calculating the Start and End Year
12:59 Calculating Date Parts
14:55 Calculating the Financial Year
18:32 Calculating the Financial Month
20:52 Calculating the Financial Quarter
22:14 Using the Financial Year Calendar
25:36 Calculating Year to Date over Financial Years
27:12 The PreviousYear Function
28:48 DatesBetween, StartOfYear and EndOfYear Functions
30:21 Calculating the Percentage of Year Total
0:39:05
DAX for Power BI Part 1 - Getting Started with DAX for Power BI
0:28:58
DAX for Power BI Part 4.1 - Getting Started with Measures
0:37:28
📊 How to use Power BI DAX - Tutorial
0:07:30
No More DAX? Power BI’s NEW Feature Explained (File Included)
0:31:39
DAX for Power BI Part 7.2 - Creating a Financial Year Calendar
0:01:00
DAX Basics: Filter CONTEXT & Calculate | Power BI Part 1 #PowerBI #design #shorts
2:54:14
Beginner Power BI DAX Functions Tutorial [Full Course]
0:17:41
DAX for Power BI Part 4.3 - Counting Values and Rows
0:30:20
DAX for Power BI Part 2.2 - The If Function
0:19:37
DAX for Power BI Part 4.5 - Quick Measures
0:44:53
DAX for Power BI Part 6.4 - Opening and Closing Balance Calculations
0:20:51
DAX for Power BI Part 2.3 - The Switch Function
0:22:24
DAX for Power BI Part 3.2 - The LookupValue Function
0:31:20
DAX for Power BI Part 6.1 - Introduction to Time Intelligence Functions
1:02:21
Learn 80% of DAX in an Hour (with FREE sample file)
0:00:45
DAX Basics: CONTEXT Transition | Power BI Part 2 #PowerBI #design #shorts
0:24:44
DAX for Power BI Part 4.4 - Using Variables
0:31:04
DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions
0:20:21
DAX for Power BI Part 4.2 - Sum, SumX and Other Aggregate Functions
0:00:58
DAX Basics: Calculated Column, MEASURES & Iterators | Power BI Part 4 #PowerBI #dax #shorts
0:29:53
DAX for Power BI Part 6.3 - Calculating Running Total or To Date Values
0:07:28
What! We don't need to learn DAX anymore? (New Power BI Feature)
0:06:00
Measures vs. calculated columns in DAX and Power BI
0:33:25
DAX for Power BI Part 2.1 - Basic Calculated Columns in DAX
Комментарии