Forum Discussion
permutation in power query (multiple rows and same columns)
Hello, I am trying to create a permutation in Power Query with the following data: Name Country Type Jason DE A Marry FR B Paul IT C US I am trying to get an...
Anonymous , Right click on each column and Create a new list, remove duplicate and convert to table and try full outer join
refer: https://exceleratorbi.com.au/cross-join-with-power-query/
In DAX a new tbale =
crossjoin(crossjoin(distinct(Table[Name]),distinct(Table[Country])),distinct(Table[Type]))
Anonymous , Right click on each column and Create a new list, remove duplicate and convert to table and try full outer join
refer: https://exceleratorbi.com.au/cross-join-with-power-query/
In DAX a new tbale =
crossjoin(crossjoin(distinct(Table[Name]),distinct(Table[Country])),distinct(Table[Type]))