From the course: Power BI Data Methods (2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Leveraging date formulas
- [Instructor] In the CDC flu data Power BI file, we select the query for the CSV file, which is the same as the SQL Server connection, which we will visit later when we examine enrichment steps for native queries. Having dates that correspond to the flu mortality numbers in a continuous standardized state formula will neighbor time series later in dashboards. In order to create a date field, we need to look at the year field and the week field. We first convert the year field into a date. However, instead of seeing that it's the first day of 2016, we instead see the 7th of July, 1905. And the reason for this is because we're converting a whole number into a date, rather than replacing the existing step. The way around this would be if we remove the change type two step and go back into the original change type step one. Then we click on the whole number data type and change it to date. Select insert and replace the current…
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.