Displaying indicator

[Nihed]

Hello,

Which can help me to display a formula as follows please:

I used this formula in power BI but I got the result as follows

Fund Budget = CONCATENATE("Fund" & " " &":"&" ",'Negative Budget Lines (list of Program+OG)'[Fund Key])

 how I can solve this problem to confess all the funds aligned please 

[Anonymous · Accepted solution]

Hi  @Nihed ,

Here are the steps you can follow：

1. Create calculated column.

Column =
   "Found"&":"&
CONCATENATEX(ALL('Negative Budget Lines (list of Program+OG)'),
 [Fund Key],",")

2. Result:

Best Regards,

Liu Yang

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