Forum Discussion

Nihed's avatar
Nihed
Helper III
3 years ago

Need Help urgent

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 
 

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    Is that a column or a measure? Below is a measure expression you can try.

     

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

     

    Pat