Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to calculate difference between two columns - related column and count column

I'm struggling with this.  I want to create a column that calculates the difference of (First RequiredShiftA) and (CountDuringShiftA) columns.   This started as two tables.  I created new columns i...
Calculations
DAX
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
ibarrau
Icon for Super User rankSuper User
7 years ago

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?