I have a table of data in Microsoft Power Bi:
IS-1 32
IS-2 76
IS-3 27
IS-4 35
IS-5 14
IS-6 81
And I need to create a new column with a function which will group those numbers in decaded so they can be easily represented in charts.
IS-1 32 31-40
IS-2 76 71-80
IS-3 27 21-30
IS-4 35 31-40
IS-5 14 11-20
IS-6 81 81-90
I know that it will be almost the same for Microsoft Excel so you can provide an Excel function.