Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
Anonymous
Not applicable

Convert measure to %...

‎08-14-2018 12:51 AM

Hi Experts

 

how would you convert the following formula to a percentage...

 

= CONCATENATE("("&DIVIDE([F2FManagementReferrals],[TotalManagementReferrals],0),")")

 

Labels:
Message 1 of 3
442 Views
0
1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

‎08-14-2018 01:01 AM

@Anonymous

 

May be...

Not Sure

 

=
CONCATENATE (
    "("
        & ROUND (
            DIVIDE ( [F2FManagementReferrals], [TotalManagementReferrals], 0 ) * 100,
            2
        ),
    "%)"
)

Regards
Zubair

Please try my custom visuals

View solution in original post

Message 2 of 3
463 Views
0
2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

‎08-14-2018 01:01 AM

@Anonymous

 

May be...

Not Sure

 

=
CONCATENATE (
    "("
        & ROUND (
            DIVIDE ( [F2FManagementReferrals], [TotalManagementReferrals], 0 ) * 100,
            2
        ),
    "%)"
)

Regards
Zubair

Please try my custom visuals
Message 2 of 3
464 Views
0
Anonymous
Not applicable
In response to Zubair_Muhammad

‎08-14-2018 01:07 AM

zUBIAR

 

many thanks, i adjusted for dplaces. excellent

Message 3 of 3
435 Views

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

View All