Power bi combine different column from DAX

Posted on by admin

Power bi combine different column from DAX

Here we will see how to combines different columns using DAX using Power BI. I will combine two-column that is Customer ID and Customer Name using DAX from the order table.

  • Open your power bi desktop. Load the Data from the Get data.
  • Go to the Data view tab. Click on New table from the ribbon.
  • Then we will write the DAX function to combine the two different columns by using Concatenate() in power bi desktop.
  • The Dax function is Combine = CONCATENATE(Orders[Customer ID],Orders[Customer Name]).

Results

Related posts:

  1. Power BI Day of the Week Name using DAX Day of Week Name In order to get the Day of Week Name from this date, which is Monday, Tuesday, Wednesday, etc. We can use the FORMAT function as below: Day of...
  2. What is Power BI Microsoft Power BI is a business intelligence (BI) platform provided by Microsoft for analyzing and visualizing raw data to present actionable information. In February 2019, Gartner confirmed Microsoft as Leader...
  3. Decision Tree with SPSS: a step by step example Decision Tree has been considered as one of the most powerful and popular data mining tools for classification and prediction. In brief, a decision tree is a type of supervised...