PQ - Details for selected country

[sandy666]

Details for selected country


CountryAreaBuilding permitsCapitalCountry/regionAbbreviationNamePopulationPersons per householdTime zone(s)CountryAttributeValue

Alabama
135,765MontgomeryUS-ALAlabama
4,874,747
2.55Central Time ZoneIndianaBuilding permits
18713

California
102,350US-CACalifornia
39,536,653Pacific Time ZoneCapitalIndianapolis

Florida
170,304TallahasseeUnited StatesFlorida
21,670,000
2.63Country/regionUnited States

Hawaii
28,311
3,369US-HI
1,427,538Hawaii-Aleutian Time ZonePopulation
6666818

Illinois
149,998Illinois
2.63Central Time Zone

Indiana
18,713IndianapolisUnited States
6,666,818

Nevada
286,367
17,952Carson CityUnited StatesUS-NVNevada
2.72Mountain Time Zone, Pacific Time Zone

New Jersey
22,608
26,793United StatesUS-NJ
9,005,644
2.73

New YorkAlbanyUS-NYNew York

Oregon
255,026
19,586United StatesUS-OROregon
4,142,776
2.51Mountain Time Zone, Pacific Time Zone

TexasAustinUS-TX
28,304,596
2.84

Washington
184,827
44,077OlympiaWashington
7,405,743
2.56Pacific Time Zone



// Country
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]
in
Source

// Data
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
UOC = Table.UnpivotOtherColumns(Source, {"Country"}, "Attribute", "Value"),
Filter = Table.SelectRows(UOC, each [Value] <> null and [Value] <> "")
in
Filter

// Result
let
Source = Table.NestedJoin(Country,{"Country"},Data,{"Country"},"Data",JoinKind.LeftOuter),
Expand = Table.ExpandTableColumn(Source, "Data", {"Attribute", "Value"}, {"Attribute", "Value"}),
ROC = Table.SelectColumns(Expand,{"Attribute", "Value"})
in
ROC