,

How to Create Tables in Microsoft Power BI Using DAX Function

Posted by

Power BI DAX is a programming language is used in Microsoft Power BI to carry out calculated columns, create tabled and custom Measures. It is used to carry out analysis on the data either Loaded from an Excel or Database, Microsoft Power Bi supports Databases Like Oracle, SQL, Postgre SQL, It also supports the use of python to carry out Advanced Data Analysis.

We can use Power BI DAX functions to create a table, We are going to explain the use of Power BI DAX to create a table using the example below:

Power BI DAX creates two columns

data 1 refers to the value in the first column and data 2 represents the value in the second column, in a situation, we want to have rows and columns, the example below shows how it is implemented.

Power BI DAX two columns and rows

Represent the first and second row of data having two columns, to be in a position to represent Multiple rows and columns in the table the sample below is what represents, Power BI usually detects the column data type whether whole number, text, or DateTime. Table = {(1,2),(3,4)}

Power BI DAX detects Column type

One thing we need to consider always in using the Power BI DAX function is to ensure that all rows have the same number of rows

Conclusion

Using the Power BI DAX Function to create a table is simple and fast, however, there are some limitations on the column names and the data types making it a challenge when doing customization.

Leave a Reply

Your email address will not be published. Required fields are marked *