Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated columns single value cannot be determined (Microsoft PowerBI tutorial)

I'm following the Microsoft tutorial for PowerBI, specifically: https://docs.microsoft.com/en-gb/learn/modules/model-data-power-bi/3-create-calculated-columns   Where it asks to create "the new Cou...
Tutorial Requests
  • johnt75's avatar
    johnt75
    4 years ago

    If there is a one-to-many relationship from Geography to Sales then in the Sales table you could use the RELATED function to get a value from Geography, so you could add a column to Sales like

    CountryZip = RELATED(Geography[Country]) & ", " & RELATED(Geography[Zip])
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

If there is a one-to-many relationship from Geography to Sales then in the Sales table you could use the RELATED function to get a value from Geography, so you could add a column to Sales like

CountryZip = RELATED(Geography[Country]) & ", " & RELATED(Geography[Zip])