Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper 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" & " " &":"&"...
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution 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