Forum Discussion
Comparing two filtered text fields in the same table and displaying the differences
Hi there! I have two calculated text visuals (Source and Target) based on the same column (Version). They are both sliced differently. I want a third calculated column to display the differences from...
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!
Hardik
Continued Contributor
Continued Contributorfirst 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 !