Forum Discussion
Anonymous
4 years agoNot applicable
Create dimension table from 2 different tables
Hi, how to create a dimension table from 2 different tables without including the (Blank) value? Below doesn't work as it includes (Blank) as one of the value which cause many to many relationship. ...
- 4 years ago
updated version:
Country = VAR vFilter = {"","null","(Blank)",BLANK()} VAR vTableA = SELECTCOLUMNS('Table A',"Country",'Table A'[Country]) VAR vTableAFilter = FILTER(vTableA,NOT( [Country] in vFilter)) VAR vTableB = SELECTCOLUMNS('Table B',"Country",'Table B'[Country]) VAR vTableBFilter = FILTER(vTableB,NOT( [Country] in vFilter)) VAR vUnion = UNION(vTableAFilter,vTableBFilter) return vUnionThis is a more dynamic approach,
1) select define values
2) select columns from source table A | B
3) Filter vTableA|B
4) Union
whereismydata
4 years agoResolver IV
Hi, in DAX or PowerQuery?
In PQ you could append those two table and then remove duplicates
- Anonymous4 years agoNot applicable
Hi whereismydata , I wanna append two tables in DAX.