From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Leveraging data types

Leveraging data types

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Leveraging data types

“

- Using the right data type in Power BI determines our success in setting up calculations. We commonly use the number data type which includes decimal numbers, fixed decimal numbers, and whole numbers. We have several date data types such as date/time, date, time, date/time/time zone, and duration. We could run into issues with date data types if the reference field is not an actual date, or if the date comes from a different locale such as Europe which uses the day/month/year format rather than the US month/day/year format. Text data types include text values, but we can also set up numeric IDs as text data types. For example, we can make numeric US zip codes a text value because we would like to retain their leading zeros. Other less frequently used data types include true/false or Boolean values, and binary which are typically file types. If we go into the US Census Power BI file we set up earlier, for the Population…

Contents