Forum Discussion
How to calculate difference between two columns - related column and count column
Super UserHi. I think I might me missing something. Did you try creating a new calculated dax column on the big table with the following formula?
Table[Column1] - Table[Column2]
Regards
I did try that but the results are no where near correct.
For example, using that formula:
instead of 2 - 2 = 0
I am getting -6
So I'm not exactly sure what is being calculated
- ibarrau
Are you sure you are checking the result in the data view?
2 - 2 = 6 sounds like having the visualization with a value of SUM of calculatedColumn.
Can you show a picture with the two columns and the substract result from the DataView?
- ibarrau
Are you sure you are checking the result in the data view?
2 - 2 = 6 sounds like having the visualization with a value of SUM of calculatedColumn.
Can you show a picture with the two columns and the substract result from the DataView?
The one column was a quick measure and doesn't show up in the data view.