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.
Well, you could use CALCULATETABLE and feed it a filter for Active. Or you could just create a table visualization and use a slicer.
To create a new column with the difference between two other columns, just use subtraction?
Greg_Deckler I tried the substraction but it didn't work. In fact, i need to return the difference in rows.
for example if
Column A
X
Y
Z
Column B
Y
Z
I want to return a new column with value Z
thanks
Now I'm really confused as that doesn't seem to be the same problem that was originally stated.
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.