Forum Discussion

Zepox's avatar
Zepox
Frequent Visitor
3 years ago

Formula becomes slow after connecting string

Hello,   I have the following formula:   Order Status = [Columns Tested] //& " / " & [Order quantity]   Which works fine, but when I uncomment the & " / " part it becomes slow to the point ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Zepox 

You can try to use CONCATENATE() function.

e.g 

Order Status = CONCATENATE([Columns Tested],"/"&[Order quantity])

And many factors may result in the slow performance  such as complex relationship between data model. You can refer to the following link to optimize the perform of calculated column.

Optimization guide for Power BI - Power BI | Microsoft Learn

Speed/Performance aspects – The BIccountant

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.