New Table - include rows from an unrelated table

[roasty1980]

Hi all

In MS Access, you can create a query that allows data to be pulled from unrelated tables

This returns a dataset that pulls all from the System Calendar table.  In this case it pulls every YYYYMM (202101, 202102, 202103 etc).  This increases the dataset size as it duplicates the other fields but it applies the YYYYMM to each row in the dateset.

Is this possible to acheive in Power BI?

Thanks

KC

[amitchandak · Accepted solution]

@roasty1980 , You can use values of the independent table using treatas

https://docs.microsoft.com/en-us/dax/treatas-function

or

calculate(sum(Table[value]), filter(Table, Table[Column] in values(Table2[Column] )))

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI