cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nihed
Helper III
Helper III

Need Help urgent

Hello,

 

Which can help me to display a formula as follows please:

 

Nihed_0-1685699340008.png

 

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])
 
Nihed_1-1685699339981.png

 

 

 how I can solve this problem to confess all the funds aligned please 
 
1 REPLY 1
ppm1
Solution Sage
Solution 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

Microsoft Employee

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors