Hi Greggyb
Please do not apologize for anything you are doing grate in helping people online and i know how hard and time consuming it is becasue i was doing this on the SSIS forum, anyways thank you and thank you to the Microsoft team putting these forum out to help people.
I am self learnning Power Bi myself and trying to make some real world examples and getting myself ready for the future of the PowerBi and Microsoft new technologies and trying to be a futur contributer at this forum like you in the future like as i did for SSIS .
Anyways i did what you asked to be more exact i am trying to doa a PriceBanding like
[Price] [Price Bracket]
1 Under 1000
2 Under 1000
.
.
1000 [1000 - 2000]
1001 [1000 - 2000]
you get the idea, so what i do is
1- click on the [Price Bracket] field
2- Click on the "sort by Column" ribon on top
3- select the [Price] field
and i get an error of .....
We Cannot sort the [Price Bracket] column by [Price] field. you can not have more than one value in the [Price] field for the same value in [Price Bracket]. choose a different column for sorting or update the data in Price$
.......
the strage thing is that it is saying the the Price$ field is not unique if you check the M code it is
the M code is like
let
Source = {1 .. 100000 },
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Price"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Price", Int64.Type}}),
#"Price Bracket" = Table.AddColumn(#"Changed Type", "PriceBand1", each
if -1 > [Price] then "Unknown"
else if 0 <= [Price] and [Price] < 1000 then "Under 1000"
else if 1000 <= [Price] and [Price] < 2000 then "[01 -2 K]"
else if 2000 <= [Price] and [Price] < 2500 then "[02 -2.5K]"
else if 2500 <= [Price] and [Price] < 3000 then "[02.5-3 K]"
else if 3000 <= [Price] and [Price] < 3500 then "[03 -3.5K]"
else if 3500 <= [Price] and [Price] < 4000 then "[03.5-4 K]"
else if 4000 <= [Price] and [Price] < 4500 then "[04 -4.5K]"
else if 4500 <= [Price] and [Price] < 5000 then "[04.5-5 K]"
else if 5000 <= [Price] and [Price] < 5500 then "[05 -5.5K]"
else if 5500 <= [Price] and [Price] < 6000 then "[05.5-6 K]"
else if 6000 <= [Price] and [Price] < 6500 then "[06 -6.5K]"
else if 6500 <= [Price] and [Price] < 7000 then "[06.5-7 K]"
else if 7000 <= [Price] and [Price] < 7500 then "[07 -7.5K]"
else if 7500 <= [Price] and [Price] < 8000 then "[07.5-8 K]"
else if 8000 <= [Price] and [Price] < 8500 then "[08 -8.5K]"
else if 8500 <= [Price] and [Price] < 9000 then "[08.5-9 K]"
else if 9000 <= [Price] and [Price] < 9500 then "[09 -9.5K]"
else if 9500 <= [Price] and [Price] < 10000 then "[09.5-10 K]"
else if 10000 <= [Price] and [Price] < 11000 then "[10-11K]"
else if 11000 <= [Price] and [Price] < 12000 then "[11-12K]"
else if 12000 <= [Price] and [Price] < 13000 then "[12-13K]"
else if 13000 <= [Price] and [Price] < 14000 then "[13-14K]"
else if 14000 <= [Price] and [Price] < 15000 then "[14-15K]"
else if 15000 <= [Price] and [Price] < 16000 then "[15-16K]"
else if 16000 <= [Price] and [Price] < 17000 then "[16-17K]"
else if 17000 <= [Price] and [Price] < 18000 then "[17-18K]"
else if 18000 <= [Price] and [Price] < 19000 then "[18-19K]"
else if 19000 <= [Price] and [Price] < 20000 then "[19-20K]"
else if 20000 <= [Price] and [Price] < 25000 then "[20-25K]"
else if 25000 <= [Price] and [Price] < 30000 then "[25-30K]"
else if 30000 <= [Price] and [Price] < 35000 then "[30-35K]"
else if 35000 <= [Price] and [Price] < 40000 then "[35-40K]"
else if 40000 <= [Price] and [Price] < 45000 then "[40-45K]"
else if 45000 <= [Price] and [Price] < 50000 then "[45-50K]"
else if 50000 <= [Price] and [Price] < 60000 then "[50-60K]"
else if 60000 <= [Price] and [Price] < 70000 then "[60-70K]"
else "[70K +")
in
#"Price Bracket"
Sincerely
Nik- Shahriar Nikkhah
