Forum Discussion
Comparing two filtered text fields in the same table and displaying the differences
The EXCEPT function appears to be used table to table, which I don't think applies here. Let me re-describe my use case.
The goal of the report is to display the software versions installed across multiple servers and display the differences. The data set is an single appended table from 16 individual Oracle connections. I have two calculated text columns (named Source and Target) that are both based on the same column (Version). They are both sliced by Environment. I want a third calculated column to display the differences between Target and Source. I'm having trouble with a custom filter seeing the passed in slicer (Environment) selections. Thanks!
Hi there! I have two calculated text visuals based on the same column (table "Source" and table "Target"), both filtered differently. I want a third calculated column to display the differences from Target to Source. The data and what I'd expect looks like this.
[Source] [Target] [Difference]
-------- -------- ------------
|1111| |0000| |1111|
|2222| |2222|
|3333| |3333|
|4444| |4444|
Thanks!
first of all change the data type of the columns from gtext to integer for subtraction by clicking on the modelling tab and later on write a dax query by creating a new column.Hope this helps !
