select * from foobar;
+-----------------------------+
| # | foo | bar |
+-----------------------------+
| 1 | one | A |
| 2 | one | C |
| 3 | one | E |
| 4 | two | B |
| 5 | t...
@bbaird and @CadeRoux : I found the DAX function RELEATED() which returns the Namefrom the State table as a new column DatabaseStateDesc, if there is an existing relationship.
2
New column with: DatabaseStateDesc = RELATED('State'[Name])
@JohnK.N. Cool, I have to do as much in the DB as possible because I need to at least attempt to be platform agnostic at the tools level, it looks like we might have our first PowerBI customer luminary relationship for our Data Mart, so as the use cases get realer and realer, we get more constrained.
select * from foobar;
+-----------------------------+
| # | foo | bar |
+-----------------------------+
| 1 | one | A |
| 2 | one | C |
| 3 | one | E |
| 4 | two | B |
| 5 | t...
