Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors