Need Help urgent

Nihed — Fri, 02 Jun 2023 09:49:34 GMT

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

Re: Need Help urgent

ppm1 — Fri, 02 Jun 2023 12:09:07 GMT

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

topic Need Help urgent in DAX Commands and Tips

Need Help urgent

Re: Need Help urgent