Forum Discussion
Solved
Display the max value in a column
Hello everyone I want to display 7.8% on the card but it gives - 0.08 as net growth rate. I've added an index column to the table and used the below formula. The formulae that I us...
Hi,
Select the measure and change to % in the measure tools that appears when you select the measure
Thejeswar
Super User
Super UserHi Nivedita ,
Your DAX will try to return the Net Growth Value in the row with Index that matches the Max Index value. I used the same DAX the you gave
By that case, 0.08 is returned as the Index for that record is greater and matches with the MAX of Index column
This 0.08 if you convert as % will show 7.8% which is the record with max value for index
Hello Thejaswar. How do I show it in percentage?
My bad, looks like it's displaying the decimal value. How do I make it 7.8%?
Thank you for your response.