Want to see what Power BI looks like when your company data is displayed, look at the Power BI demo. Here you can click around and get a feeling with the value of Power BI.
Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Since the release of Pokemon Go in The Netherlands a week ago, an enormous amount of people plays the game. You constantly see groups of people walk through the street in search for their new Pokemon. As datalovers, we couldn’t resist putting some data inside Power BI to get a better grip on where to start with Pokemon Go.
Chances are that you, your children or even your parents play Pokemon Go. To directly make a great start, we show the Pokemon Characters you must “find” to become a star in the game in the Power BI Dashboard.
Want to see what Power BI looks like when your company data is displayed, look at the Power BI demo. Here you can click around and get a feeling with the value of Power BI.
eyJrIjoiOTY1MTJiMmMtOTQ3Zi00NmY3LTk0ZTctZWIwYmZkYzk2ZTk5IiwidCI6IjQxMGJiOTRmLTg0ODgtNGIzMy05MDg3LTQzNTU3OTZjNzcyYyIsImMiOjh9
Hi Greg,
That's unfortunately the problem when you're using an extrenal site as a source.
You can download the new file attached in this post OR
You can change the code in the query editor from the table Pokemon Figures in: (not al URL's are listed)
let Source = Web.Page(Web.Contents("http://pokemongo.gamepress.gg/pokemon-list")), Data = Source{2}[Data], #"Changed Type" = Table.TransformColumnTypes(Data,{{"Pokemon", type text}, {"Stats", type any}, {"CP", Int64.Type}, {"Rating", type text}}), #"Expanded Stats" = Table.ExpandTableColumn(#"Changed Type", "Stats", {"Column1", "Column2", "Column3"}, {"Stats.Column1", "Stats.Column2", "Stats.Column3"}), #"Renamed Columns" = Table.RenameColumns(#"Expanded Stats",{{"Stats.Column1", "HP"}, {"Stats.Column2", "Atk"}, {"Stats.Column3", "Def"}, {"CP", "Max CP"}, {"Pokemon", "Name"}}), #"Removed Duplicates" = Table.Distinct(#"Renamed Columns", {"Name"}), #"Added Index" = Table.AddIndexColumn(#"Removed Duplicates", "Index", 1, 1), #"Reordered Columns" = Table.ReorderColumns(#"Added Index",{"Index", "Name", "HP", "Atk", "Def", "Max CP", "Rating"}), #"Added Conditional Column" = Table.AddColumn(#"Reordered Columns", "URL", each if [Index] = 1 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_001_00.png" else if [Index] = 2 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_002_00.png" else if [Index] = 3 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_003_00.png" else if [Index] = 4 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_004_00.png" else if [Index] = 5 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_005_00.png" else if [Index] = 6 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_006_00.png" else if [Index] = 7 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_007_00.png" else if [Index] = 8 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_008_00.png" else if [Index] = 9 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_009_00.png" else if [Index] = 10 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_010_00.png" else if [Index] = 11 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_011_00.png" else if [Index] = 12 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_012_00.png" else if [Index] = 13 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_013_00.png" else if [Index] = 14 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_014_00.png" else if [Index] = 15 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_015_00.png" else if [Index] = 16 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_016_00.png" else if [Index] = 17 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_017_00.png" else if [Index] = 18 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_018_00.png" else if [Index] = 19 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_019_00.png" else if [Index] = 20 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_020_00.png" else if [Index] = 21 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_021_00.png" else if [Index] = 22 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_022_00.png" else if [Index] = 23 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_023_00.png" else if [Index] = 24 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_024_00.png" else if [Index] = 25 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_025_00.png" else if [Index] = 26 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_026_00.png" else if [Index] = 27 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_027_00.png" else if [Index] = 28 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_028_00.png" else if [Index] = 29 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_029_00.png" else if [Index] = 30 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_030_00.png" else if [Index] = 31 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_031_00.png" else if [Index] = 32 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_032_00.png" else if [Index] = 33 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_033_00.png" else if [Index] = 34 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_034_00.png" else if [Index] = 35 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_035_00.png" else if [Index] = 36 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_036_00.png" else if [Index] = 37 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_037_00.png" else if [Index] = 38 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_038_00.png" else if [Index] = 39 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_039_00.png" else if [Index] = 40 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_040_00.png" else if [Index] = 41 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_041_00.png" else if [Index] = 42 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_042_00.png" else if [Index] = 43 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_043_00.png" else if [Index] = 44 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_044_00.png" else if [Index] = 45 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_045_00.png" else if [Index] = 46 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_046_00.png" else if [Index] = 47 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_047_00.png" else if [Index] = 48 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_048_00.png" else if [Index] = 49 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_049_00.png" else if [Index] = 50 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_050_00.png" else if [Index] = 51 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_051_00.png" else if [Index] = 52 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_052_00.png" else if [Index] = 53 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_053_00.png" else if [Index] = 54 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_054_00.png" else if [Index] = 55 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_055_00.png" else if [Index] = 56 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_056_00.png" else if [Index] = 57 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_057_00.png" else if [Index] = 58 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_058_00.png" else if [Index] = 59 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_059_00.png" else if [Index] = 60 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_060_00.png" else if [Index] = 61 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_061_00.png" else if [Index] = 62 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_062_00.png" else if [Index] = 63 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_063_00.png" else if [Index] = 64 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_064_00.png" else if [Index] = 65 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_065_00.png" else if [Index] = 66 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_066_00.png" else if [Index] = 67 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_067_00.png" else if [Index] = 68 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_068_00.png" else if [Index] = 69 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_069_00.png" else if [Index] = 70 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_070_00.png" else if [Index] = 71 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_071_00.png" else if [Index] = 72 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_072_00.png" else if [Index] = 73 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_073_00.png" else if [Index] = 74 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_074_00.png" else if [Index] = 75 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_075_00.png" else if [Index] = 76 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_076_00.png" else if [Index] = 77 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_077_00.png" else if [Index] = 78 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_078_00.png" else if [Index] = 79 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_079_00.png" else if [Index] = 80 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_080_00.png" else if [Index] = 81 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_081_00.png" else if [Index] = 82 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_082_00.png" else if [Index] = 83 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_083_00.png" else if [Index] = 84 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_084_00.png" else if [Index] = 85 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_085_00.png" else if [Index] = 86 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_086_00.png" else if [Index] = 87 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_087_00.png" else if [Index] = 88 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_088_00.png" else if [Index] = 89 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_089_00.png" else if [Index] = 90 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_090_00.png" else if [Index] = 91 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_091_00.png" else if [Index] = 92 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_092_00.png" else if [Index] = 93 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_093_00.png" else if [Index] = 94 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_094_00.png" else if [Index] = 95 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_095_00.png" else if [Index] = 96 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_096_00.png" else if [Index] = 97 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_097_00.png" else if [Index] = 98 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_098_00.png" else if [Index] = 99 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_099_00.png" else if [Index] = 100 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_100_00.png" else if [Index] = 101 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_101_00.png" else if [Index] = 102 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_102_00.png" else if [Index] = 103 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_103_00.png" else if [Index] = 104 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_104_00.png" else if [Index] = 105 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_105_00.png" else if [Index] = 106 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_106_00.png" else if [Index] = 107 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_107_00.png" else if [Index] = 108 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_108_00.png" else if [Index] = 109 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_109_00.png" else if [Index] = 110 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_110_00.png" else if [Index] = 111 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_111_00.png" else if [Index] = 112 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_112_00.png" else if [Index] = 113 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_113_00.png" else if [Index] = 114 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_114_00.png" else if [Index] = 115 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_115_00.png" else if [Index] = 116 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_116_00.png" else if [Index] = 117 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_117_00.png" else if [Index] = 118 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_118_00.png" else if [Index] = 119 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_119_00.png" else if [Index] = 120 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_120_00.png" else if [Index] = 121 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_121_00.png" else if [Index] = 122 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_122_00.png" else if [Index] = 123 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_123_00.png" else if [Index] = 124 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_124_00.png" else if [Index] = 125 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_125_00.png" else if [Index] = 126 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_126_00.png" else if [Index] = 127 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_127_00.png" else if [Index] = 128 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_128_00.png" else if [Index] = 129 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_129_00.png" else if [Index] = 130 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_130_00.png" else if [Index] = 131 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_131_00.png" else if [Index] = 132 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_132_00.png" else if [Index] = 133 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_133_00.png" else if [Index] = 134 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_134_00.png" else if [Index] = 135 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_135_00.png" else if [Index] = 136 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_136_00.png" else if [Index] = 137 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_137_00.png" else if [Index] = 138 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_138_00.png" else if [Index] = 139 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_139_00.png" else if [Index] = 140 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_140_00.png" else if [Index] = 141 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_141_00.png" else if [Index] = 142 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_142_00.png" else if [Index] = 143 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_143_00.png" else if [Index] = 144 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_144_00.png" else if [Index] = 145 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_145_00.png" else if [Index] = 146 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_146_00.png" else if [Index] = 147 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_147_00.png" else if [Index] = 148 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_148_00.png" else if [Index] = 149 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_149_00.png" else if [Index] = 150 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_150_00.png" else if [Index] = 151 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_151_00.png" else null, type text) in #"Added Conditional Column"
Can you share a picture when you're sharing the report with the Kids? Will be nice 🙂
Regards,
Jorre van Geerenstein
Could you please update the URL image query? I tried downloading your PBIX and fixing it but am stuck on how to structure the syntax now that the pokemon list site has changed. I would love to use this report when I am presenting to kids for our STEM Outreach programs! Thanks for the consideration.
Hi Greg,
That's unfortunately the problem when you're using an extrenal site as a source.
You can download the new file attached in this post OR
You can change the code in the query editor from the table Pokemon Figures in: (not al URL's are listed)
let Source = Web.Page(Web.Contents("http://pokemongo.gamepress.gg/pokemon-list")), Data = Source{2}[Data], #"Changed Type" = Table.TransformColumnTypes(Data,{{"Pokemon", type text}, {"Stats", type any}, {"CP", Int64.Type}, {"Rating", type text}}), #"Expanded Stats" = Table.ExpandTableColumn(#"Changed Type", "Stats", {"Column1", "Column2", "Column3"}, {"Stats.Column1", "Stats.Column2", "Stats.Column3"}), #"Renamed Columns" = Table.RenameColumns(#"Expanded Stats",{{"Stats.Column1", "HP"}, {"Stats.Column2", "Atk"}, {"Stats.Column3", "Def"}, {"CP", "Max CP"}, {"Pokemon", "Name"}}), #"Removed Duplicates" = Table.Distinct(#"Renamed Columns", {"Name"}), #"Added Index" = Table.AddIndexColumn(#"Removed Duplicates", "Index", 1, 1), #"Reordered Columns" = Table.ReorderColumns(#"Added Index",{"Index", "Name", "HP", "Atk", "Def", "Max CP", "Rating"}), #"Added Conditional Column" = Table.AddColumn(#"Reordered Columns", "URL", each if [Index] = 1 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_001_00.png" else if [Index] = 2 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_002_00.png" else if [Index] = 3 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_003_00.png" else if [Index] = 4 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_004_00.png" else if [Index] = 5 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_005_00.png" else if [Index] = 6 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_006_00.png" else if [Index] = 7 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_007_00.png" else if [Index] = 8 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_008_00.png" else if [Index] = 9 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_009_00.png" else if [Index] = 10 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_010_00.png" else if [Index] = 11 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_011_00.png" else if [Index] = 12 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_012_00.png" else if [Index] = 13 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_013_00.png" else if [Index] = 14 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_014_00.png" else if [Index] = 15 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_015_00.png" else if [Index] = 16 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_016_00.png" else if [Index] = 17 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_017_00.png" else if [Index] = 18 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_018_00.png" else if [Index] = 19 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_019_00.png" else if [Index] = 20 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_020_00.png" else if [Index] = 21 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_021_00.png" else if [Index] = 22 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_022_00.png" else if [Index] = 23 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_023_00.png" else if [Index] = 24 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_024_00.png" else if [Index] = 25 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_025_00.png" else if [Index] = 26 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_026_00.png" else if [Index] = 27 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_027_00.png" else if [Index] = 28 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_028_00.png" else if [Index] = 29 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_029_00.png" else if [Index] = 30 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_030_00.png" else if [Index] = 31 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_031_00.png" else if [Index] = 32 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_032_00.png" else if [Index] = 33 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_033_00.png" else if [Index] = 34 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_034_00.png" else if [Index] = 35 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_035_00.png" else if [Index] = 36 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_036_00.png" else if [Index] = 37 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_037_00.png" else if [Index] = 38 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_038_00.png" else if [Index] = 39 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_039_00.png" else if [Index] = 40 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_040_00.png" else if [Index] = 41 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_041_00.png" else if [Index] = 42 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_042_00.png" else if [Index] = 43 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_043_00.png" else if [Index] = 44 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_044_00.png" else if [Index] = 45 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_045_00.png" else if [Index] = 46 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_046_00.png" else if [Index] = 47 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_047_00.png" else if [Index] = 48 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_048_00.png" else if [Index] = 49 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_049_00.png" else if [Index] = 50 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_050_00.png" else if [Index] = 51 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_051_00.png" else if [Index] = 52 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_052_00.png" else if [Index] = 53 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_053_00.png" else if [Index] = 54 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_054_00.png" else if [Index] = 55 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_055_00.png" else if [Index] = 56 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_056_00.png" else if [Index] = 57 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_057_00.png" else if [Index] = 58 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_058_00.png" else if [Index] = 59 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_059_00.png" else if [Index] = 60 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_060_00.png" else if [Index] = 61 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_061_00.png" else if [Index] = 62 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_062_00.png" else if [Index] = 63 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_063_00.png" else if [Index] = 64 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_064_00.png" else if [Index] = 65 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_065_00.png" else if [Index] = 66 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_066_00.png" else if [Index] = 67 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_067_00.png" else if [Index] = 68 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_068_00.png" else if [Index] = 69 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_069_00.png" else if [Index] = 70 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_070_00.png" else if [Index] = 71 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_071_00.png" else if [Index] = 72 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_072_00.png" else if [Index] = 73 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_073_00.png" else if [Index] = 74 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_074_00.png" else if [Index] = 75 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_075_00.png" else if [Index] = 76 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_076_00.png" else if [Index] = 77 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_077_00.png" else if [Index] = 78 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_078_00.png" else if [Index] = 79 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_079_00.png" else if [Index] = 80 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_080_00.png" else if [Index] = 81 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_081_00.png" else if [Index] = 82 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_082_00.png" else if [Index] = 83 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_083_00.png" else if [Index] = 84 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_084_00.png" else if [Index] = 85 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_085_00.png" else if [Index] = 86 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_086_00.png" else if [Index] = 87 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_087_00.png" else if [Index] = 88 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_088_00.png" else if [Index] = 89 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_089_00.png" else if [Index] = 90 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_090_00.png" else if [Index] = 91 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_091_00.png" else if [Index] = 92 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_092_00.png" else if [Index] = 93 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_093_00.png" else if [Index] = 94 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_094_00.png" else if [Index] = 95 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_095_00.png" else if [Index] = 96 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_096_00.png" else if [Index] = 97 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_097_00.png" else if [Index] = 98 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_098_00.png" else if [Index] = 99 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_099_00.png" else if [Index] = 100 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_100_00.png" else if [Index] = 101 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_101_00.png" else if [Index] = 102 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_102_00.png" else if [Index] = 103 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_103_00.png" else if [Index] = 104 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_104_00.png" else if [Index] = 105 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_105_00.png" else if [Index] = 106 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_106_00.png" else if [Index] = 107 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_107_00.png" else if [Index] = 108 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_108_00.png" else if [Index] = 109 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_109_00.png" else if [Index] = 110 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_110_00.png" else if [Index] = 111 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_111_00.png" else if [Index] = 112 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_112_00.png" else if [Index] = 113 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_113_00.png" else if [Index] = 114 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_114_00.png" else if [Index] = 115 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_115_00.png" else if [Index] = 116 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_116_00.png" else if [Index] = 117 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_117_00.png" else if [Index] = 118 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_118_00.png" else if [Index] = 119 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_119_00.png" else if [Index] = 120 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_120_00.png" else if [Index] = 121 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_121_00.png" else if [Index] = 122 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_122_00.png" else if [Index] = 123 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_123_00.png" else if [Index] = 124 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_124_00.png" else if [Index] = 125 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_125_00.png" else if [Index] = 126 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_126_00.png" else if [Index] = 127 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_127_00.png" else if [Index] = 128 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_128_00.png" else if [Index] = 129 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_129_00.png" else if [Index] = 130 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_130_00.png" else if [Index] = 131 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_131_00.png" else if [Index] = 132 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_132_00.png" else if [Index] = 133 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_133_00.png" else if [Index] = 134 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_134_00.png" else if [Index] = 135 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_135_00.png" else if [Index] = 136 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_136_00.png" else if [Index] = 137 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_137_00.png" else if [Index] = 138 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_138_00.png" else if [Index] = 139 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_139_00.png" else if [Index] = 140 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_140_00.png" else if [Index] = 141 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_141_00.png" else if [Index] = 142 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_142_00.png" else if [Index] = 143 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_143_00.png" else if [Index] = 144 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_144_00.png" else if [Index] = 145 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_145_00.png" else if [Index] = 146 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_146_00.png" else if [Index] = 147 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_147_00.png" else if [Index] = 148 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_148_00.png" else if [Index] = 149 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_149_00.png" else if [Index] = 150 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-01/pokemon_icon_150_00.png" else if [Index] = 151 then "https://pokemongo.gamepress.gg/sites/pokemongo/files/2018-03/pokemon_icon_151_00.png" else null, type text) in #"Added Conditional Column"
Can you share a picture when you're sharing the report with the Kids? Will be nice 🙂
Regards,
Jorre van Geerenstein
would you consider doing other data stories for the other pokedexs in the game?