Forum Discussion
Cannot Post from Power BI Desktop
Hi,
I have a number of values that I want to group in power bi desktop query.
how do I do it in power bi desktop query. see an example below
somthing like this in dax powerpivot
If (myColumn < 1100,1000,If myColumn < 1200,1100,.....)
Any advice please?
Many thanks,
Ferri
Output should be like this
My Column NyCoulumn
1000 1000
1001 1000
1005 1000
1020 1000
1100 1100
1106 1100
1155 1100
1200 1200
1210 1200
1285 1200
1247 1200
10000 10000
10025 10000
Ferri SWITCH does compare the values...
It takes the initial column value that you want to compare, and will evaluate each value on the expression list you define. Then replacing the value range to the static value you want..
Here is an example of using this in a calculated column which you can name "NyCoulumn"
SWITCH(TRUE(),
AND([MyColumn] >=0, [MyColumn] <=1099), "1000"
AND([MyColumn] >=1100, [MyColumn] <=1199), "1100"
AND([MyColumn] >=1200, [MyColumn] <=1299), "1200"
"1200+"
3 Replies
Ferri you could use an "IF", but SWITCH is less verbose.
Check out this blog to guide you, and help you understand how to do this now and in future cases.
http://www.powerpivotpro.com/2012/06/dax-making-the-case-for-switch/
thanks for the help, but I need to compare the values therefore i will use if..else.
Ferri SWITCH does compare the values...
It takes the initial column value that you want to compare, and will evaluate each value on the expression list you define. Then replacing the value range to the static value you want..
Here is an example of using this in a calculated column which you can name "NyCoulumn"
SWITCH(TRUE(),
AND([MyColumn] >=0, [MyColumn] <=1099), "1000"
AND([MyColumn] >=1100, [MyColumn] <=1199), "1100"
AND([MyColumn] >=1200, [MyColumn] <=1299), "1200"
"1200+"
