Solved: Concatenate two measure with seperator

Anonymous · ‎04-03-2023

Hi Experts

How can i amend the following to measure to show the following end result

Measure

Risk Control Breadown Country = CONCATENATE(FORMAT([Substantiated],"###"),FORMAT([Closed],"###"))

53/5253

vanessafvg · ‎04-03-2023

CONCATENATEX (
    FORMAT ( [Substantiated], "###" ),
    "/",
    FORMAT ( [Closed], "###" )
)

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

View solution in original post

vanessafvg · ‎04-03-2023

CONCATENATEX (
    FORMAT ( [Substantiated], "###" ),
    "/",
    FORMAT ( [Closed], "###" )
)

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Concatenate two measure with seperator

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - January 2025

Fabric Community Update - January 2025

How to Get Your Question Answered Quickly

New Offer! Become a Certified Fabric Data Engineer