DAX in Practice: Text and Data Transformations
Instructor: Andrew McSwiggan
Developers and analysts need to format text strings and timestamps in different ways to aid visual analysis. This course will teach you how to use DAX functions to create new text and date columns that can be used for presenting data in Power BI.
What you’ll learn
Developers and analysts need to analyze sales data by different product attributes such as type, size, and color, and by different time ranges such as week, month, and year. You need to extract and transform this base data into a series of new text and date columns to use in your analysis to slice, dice, and present the data in Power BI. One way to achieve this is to use the DAX language which is available inside every Power BI report to change the shape of the data.
When you’re finished with this course, you’ll know how to create new text and date columns in Power BI with DAX.
