support

[Mirithu]

Hi everyone,

I have a pivot table in excel that shows the range of values in an amount data column as follows:

I would like to show the this range column in a PowerBI table. I have tried using binning but it does not give the same result.

How do I resolve this?

Thank you.

[Greg_Deckler · Accepted solution]

Create a calculated column using SWITCH statement?

[v-chuncz-msft · Accepted solution]

@Mirithu,

Here is an example for your reference.

[v-chuncz-msft · Accepted solution]

@Mirithu,

Here is an example for your reference.

[Greg_Deckler · Accepted solution]

Create a calculated column using SWITCH statement?

[Mirithu · Accepted solution]

Hi,

SWITCH works perfectly. Thank you!