Calculated column based on other column with intervals of 500

[Anonymous]

So I have a column, which has value ranges from 0 to 1 million. 

I want to create a calculated column that will create intervals per 500. I know you can achieve this goal by using a switch, but it's a bit much to do this like that. 

Is there any other method? 

[selimovd · Accepted solution]

Hey @Anonymous ,

you can do that without SWITCH.

Like this you would create segments in 500 steps (0-500 would be segment 500, 501-1000 would be segment 100, etc.):

Segment =
(
    ROUNDDOWN(
        myTable[myNumber] / 500,
        0
    ) + 1
) * 500

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Great thank you. Sometimes it's so simple you don't think about it! 😁