Forum Discussion
Nihed
3 years agoHelper III
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
3 years agoSolution Sage
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