Forum Discussion
abukapsoun
Post Patron
Post PatronCalculated Columns
Hi Dears, I have the following case please: Column1 Column2 X Active Y Obselete Z Active How can I create a new (column or table?) that retur...
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.
Select “Active” for Column2 in Visual level filters, and right click on your table, select "New Column" and apply the following formula.
Column = Table1[Column4]-Table1[Column3]
Regards,
Lydia