Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sarah Fox]

Hi there,

I am wanting to display decimal values as fractions, e.g 3/5 as 3/5 and not 0.6 etc. 

I have tried using the following DAX function from https://community.powerbi.com/t5/Desktop/show-numbers-as-fraction/m-p/125253 :

Fraction =
var given=2.5
var precision=100000
return (given*precision/GCD(given*precision,precision))&”/”&(precision/GCD(given*precision,precision))

It is working well for the most part but I am getting a number like this for a value that should be 15/26. 

Also, I would like it to say, for example 2/2 or 5/5 instead of 1/1 in the case of a whole number. How do I do this? 

 

Thanks so much in advance.  

——————————
Sarah Fox
——————————

[Samyr Abrahão Moises]

Check if this post helps you: Solved: Convert Decimals to Custom Fractions – Microsoft Power BI Community

Cheers!

——————————
Samyr Abrahão Moises
——————————
——————————————-

[James Watts]

I think you are expecting too much.  The GCD function can only return factors of the precision – so for this value of 10,000, it will be multiples of 2 and 5.  It is never going to reduce the divisor to 26.  The GCD of 5,769 and 10,000 is 1.

Also, you should put a ROUND(,0) on the RETURN value to get rid of the decimal places in the numerator:

RETURN ROUND((given*precision/GCD(given*precision,precision)) ,0) &”/”&(precision/GCD(given*precision,precision))

——————————
James Watts
Business Intelligence Analyst
——————————
——————————————-