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 in my larger table to add the related columns of the required roles, shift a, and shift b thinking that once they were in the same table it would be easy to just subtract one column from the other - nope.

 

 

 

Calculations
DAX

11 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    7 years ago

    Hi. 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I did try that but the results are no where near correct.  

       

       

    • 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?