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" & " " &":"&" ",...
  • 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