cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
igordossantos Regular Visitor
Regular Visitor

FORMAT setting integer to string - DAX

All, 

What am I doing in correctly on the formula below?

 

% Profiles Started = VALUE ( FORMAT ( DIVIDE ( TotalNumberOfSkills, [Total # Resources] ) * 100, "0.0" ) )

 

The result of the above is returning a string value.

 

Am I doing something incorrectly? Is there an alternative to formatting percentages in DAX? 

2 REPLIES 2
Vvelarde Super Contributor
Super Contributor

Re: FORMAT setting integer to string - DAX

@igordossantos

 

The change the format you can go to modeling:

 

%.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




v-ljerr-msft Super Contributor
Super Contributor

Re: FORMAT setting integer to string - DAX

Hi @igordossantos,

 

You don't need to use DAX functions to format the value of the measure in this scenario. In Power BI Desktop, you can just use Format option under Modeling tab to format the measure as Vvelarde mentioned above.

 

You can just use the formula below for the measure "% Profiles Started", then follow steps below to change format to Percentage for it.

% Profiles Started = DIVIDE ( TotalNumberOfSkills, [Total # Resources] )

1. Select the measure you want to format on the Fields.

 

m1.PNG

 

2. Under Modeling tab, just choose Percentage for the Format of the measure.

 

f1.PNG

 

Regards

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 139 members 1,758 guests
Please welcome our newest community members: