Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SWITCH function failing wiht measures

Hello community, I hope you can help me with this.   I am working with a SQL Database into my Power BI desktop, in which I have 'Deal ID' and 'Amount', and I am trying to create a custom column to ...
Need Help
Danke1981's avatar
Danke1981
New Member
7 years ago

Another solution would be:

Grouping the amount first

                                                                  Group

[Amount]<=5000,                                       "1"
5000<[Amount]<=10000,                           "2"
10000<[Amount]<=20000,                         "3"

20000<[Amount]<=50000,                         "4"

.

.

.

Then use swith function:

WITCH(
       TRUE(),
  [Group]=1 ,”<5K″,
  [Group]=2 ,”5-10K″,

.

.

.

.