Forum Discussion

johkel's avatar
johkel
Copper Contributor
Apr 05, 2023
Solved

using a column of geography data with formulas

Hi, I've created a map chart from a column of country names which has been converted to geography data. I would like to create a new column referencing the country name and looking up in an array in ...
Charting
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 05, 2023

johkel 

Or

=LET(
    names, UNIQUE(country[Country].Name),
    counts, MAP(
        names,
        LAMBDA(c,
            REDUCE(
                0,
                country[Country],
                LAMBDA(a,v, a + (v.Name = c))
            )
        )
    ),
    VSTACK({"Country","#"}, HSTACK(names, counts))
)

to generate

Resources