Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

I'm stumped on a seemingly simple format issue for Power BI. I'm trying to format the remainder of a number into a custom fraction (13ths)

For example 755.38 should show as 755 5/13

In Excel, I use the custom fraction formula "# #/13"

In DAX I'm using the FORMAT function with the format as "#. #/13".

This just takes the remainder and displays it with a "/13" on the end. it does not divide the remainder correctly.

Example 755.38 is showing as 755. 4/13 when the correct calculation is 755 5/13

1 Answer

0 votes
by (47.2k points)
  • you can put the pieces together yourself. For example,

Measure = VAR Num = SUM(Table1[Number]) VAR Frac = ROUND(13*(Num - INT(Num)), 0) RETURN FORMAT(INT(Num), "0 ") & Frac & "/13"

Samle Output

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Mar 15 in BI by vyeshma (27.7k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.6k answers

500 comments

108k users

Browse Categories

...