From the course: Advanced Power BI: DAX Language, Formulas, and Calculations
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Power BI summarized view - Power BI Tutorial
From the course: Advanced Power BI: DAX Language, Formulas, and Calculations
Power BI summarized view
- [Instructor] When a visual design looks good, we like it more and sometimes we can't explain exactly why. But what we may not realize is this is because what we're looking at follows good design principles. There are courses in the library that focus a lot more on how to design effective Power BI dashboards or report views, but even just organizing our existing loan models a bit can make a big impact on how we communicate our results to a wider audience. A few design principles that I've found immensely helpful in building Power BI models that effectively communicate data outcomes to the end users include using a maximum of three visuals on a single page, adding clear labels to charts and choosing a few colors to use effectively. We want to make sure we're using the space on a Power BI page effectively. Humans commonly read from the top left corner across the top right and down the page, much like the letter F. I don't…
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.
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
-
-