DAX in Practice: Text and Data Transformations
Category: Tutorials
- views: 201
- date: 30 November 2024
- posted by: AD-TEAM
DAX in Practice: Text and Data Transformations
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 13m | 184 MB
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.
In this course, DAX in Practice: Text and Data Transformations, you'll learn how to write basic DAX code to manipulate text and date columns to extract parts of the data, format it, and store it in new columns in your Power BI report. First, you'll learn how to extract text positions within a text string with DAX and use these positions to navigate the text string and cut out different parts of the text. Next, you'll learn about the challenges of analyzing data over time, and how to manipulate datetime columns with DAX to solve these problems. Finally, you'll learn how to save the results of these DAX formulas into new columns in Power BI.
When you're finished with this course, you'll know how to create new text and date columns in Power BI with DAX.
More Info
We need your support!
Make a donation to help us stay online
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem
Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u
USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm
Information |
|||
 |
Users of GUESTS are not allowed to comment this publication. | ||