2 multiple choice 1 point what is the purpose of using functions like concatenate in data transformation in…

2 multiple choice 1 point what is the purpose of using functions like concatenate in data transformation in power bi? to create relationships between tables in the data model. to combine or modify data values for meaningful insights. to calculate statistical measures on the data. to apply conditional logic for data filtering.

2 multiple choice 1 point what is the purpose of using functions like concatenate in data transformation in power bi? to create relationships between tables in the data model. to combine or modify data values for meaningful insights. to calculate statistical measures on the data. to apply conditional logic for data filtering.

Answer

Brief Explanations:

The CONCATENATE function in Power - BI is used to combine text strings or data values. This helps in getting more meaningful insights by creating new combined data elements. It is not for creating table relationships, calculating statistics, or applying conditional logic for filtering.

Answer:

To combine or modify data values for meaningful insights.