Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Concatenate a field within IF/SWITCH statement

Hello Everyone,  I'm new to Power BI. I have created new column in my report using this SWITCH statement to group Instituitions based on below conditions.  What i want is Concat "Control Group1" wit...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous well adding the column at the source is your best bet.

Venkat4400's avatar
Venkat4400
Frequent Visitor
5 years ago

Hi,

 

I can propose two options: Just try and let me know

1> Make sure that column data type is correct (Text,Whole number etc) - Check at front end and back end

If yes,try to create the formula by using Cal.Column 

2>If it doesn't help - Push this logic to back end,so that you can get rid of this issue and also improve the query performance (since you were using direct mode)

 

Regards,

Venkat