Forum Discussion
New Table - include rows from an unrelated table
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
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
1 Reply
- amitchandak
Super User
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