Forum Discussion
Calculated Columns
I would look at using NATURALOUTERJOIN if you are going to do this in DAX:
https://msdn.microsoft.com/en-us/library/dn802527.aspx
You could also use a Merge Query in the Query Editor and accomplish this as well, just change the default join type.
Greg_Deckler Sorry it seems I have explained myself wrong.
for the first problem it is clear about the calculatedtable with filter = Active
but now I am stuck with returning the differences between the two column. What I want to reach is the following. I have a column that is being updated dynamically. I have duplicated this table and disabled the "load on refresh" then I want to compare both and return what has been newly added compared to that static column which is not refreshing anymore.
I would look at using NATURALOUTERJOIN if you are going to do this in DAX:
https://msdn.microsoft.com/en-us/library/dn802527.aspx
You could also use a Merge Query in the Query Editor and accomplish this as well, just change the default join type.