From the course: Advanced Power BI: DAX Language, Formulas, and Calculations
Join today to access over 24,600 courses taught by industry experts.
Challenge: DAX time intelligence modeling - Power BI Tutorial
From the course: Advanced Power BI: DAX Language, Formulas, and Calculations
Challenge: DAX time intelligence modeling
(upbeat music) - [Instructor] Your goal for this chapter's part of the challenge is to pick a single crop from the Power BI model for US crop data. You'll then use the rate of growth already calculate in the previous chapter to compare its projected growth to its actual growth. Lastly, you'll then want to create a chart to compare the actuals versus the projections you just calculated.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
-
SELECTEDVALUE DAX function6m 22s
-
(Locked)
IF DAX function for conditional formulas6m 46s
-
(Locked)
EOMONTH DAX function4m 49s
-
(Locked)
DATEDIFF DAX function4m 34s
-
(Locked)
BLANK and ISBLANK DAX functions6m 33s
-
(Locked)
Filtering between tables5m 10s
-
(Locked)
DAX acrobatics6m 18s
-
(Locked)
GENERATE and ROW DAX functions with calculated dates tables7m 43s
-
(Locked)
DATESBETWEEN DAX function4m 1s
-
(Locked)
DATEADD DAX function4m
-
(Locked)
MTD, QTD, and YTD date DAX functions4m 1s
-
(Locked)
DAX quick measures6m 22s
-
(Locked)
Power BI summarized view5m 43s
-
(Locked)
Challenge: DAX time intelligence modeling27s
-
(Locked)
Solution: DAX time intelligence modeling3m 32s
-
-