Forum Discussion

Nihed's avatar
Nihed
Helper III
3 years ago
Solved

Displaying indicator

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's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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