Forum Discussion

paulfink's avatar
paulfink
Icon for Post Patron rankPost Patron
6 years ago

Subtracting Columns from 2 Tables

Hi guys,   i need help with DAX as im trying to subtract two columns in two different tables but they each have columns with the same names which i need so that i can have a total.   What i am tr...
Need Help
paulfink's avatar
paulfink
Icon for Post Patron rankPost Patron
6 years ago

hi guys,

 

its okay now, no need to help.

 

it somehow fixed itself.

 

the A-B did not work it only showed the subtracted on each row so no change but i made a new visual and put in names->subtracted-> amount -> time -> etc. and it worked. So thank you for your help!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Paulfink

     

    That is because of the difference between a column and a measure in PowerBI. The measure you created will be calculated dynamically - so when you added Column C to a visual it will then perform your calculation (A - B) split by column C, although the underlying data doesn't change.