Reply
Highlighted
Regular Visitor
Posts: 33
Registered: ‎07-24-2015

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? 

Super User
Posts: 1,684
Registered: ‎05-10-2016

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!




Super Contributor
Posts: 3,697
Registered: ‎07-17-2016

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