Pokémon GO 05-20-2018 22:52 PM

[Jorre94]

WHAT HAS POKEMON GO TO DO WITH BUSINESS INTELLIGENCE AND POWER BI?

NOT MUCH! BUT STILL THE COMBINATION COULD BE VERY INTERESTING. SOME INFO ON POKEMON GO: IT IS A GAME THAT USES AUGMENTED REALITY. THAT MEANS THAT THE DIGITAL GAME TAKES PLACE IN YOUR OWN ANALOG ENVIRONMENT THROUGH THE LENS OF THE CAMERA. SO YOU CAN WALK THROUGH THE PARK AND SPOT A REALLY RARE POKEMON IN FRONT OF YOU. AT THAT MOMENT YOU NEED TO CATCH IT AND TRAIN IT.

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.

Pokémon Blog

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.

TO THE POWER BI DEMO

eyJrIjoiOTY1MTJiMmMtOTQ3Zi00NmY3LTk0ZTctZWIwYmZkYzk2ZTk5IiwidCI6IjQxMGJiOTRmLTg0ODgtNGIzMy05MDg3LTQzNTU3OTZjNzcyYyIsImMiOjh9

[gregpetrossian]

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.

[Jorre94]

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

[Anonymous]

would you consider doing other data stories for the other pokedexs in the game?

[gregpetrossian]

The kids loved it!!! Thanks for making the major fix. I went ahead and did a small fix for the three dragon pokemon that still weren't working. PBIX attached and photo from class attached