The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
User | Count |
---|---|
12 | |
9 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |