Forum Discussion

troubledlady's avatar
troubledlady
New Member
3 years ago

How to calculate difference column between two columns from different data source in Matrix table?

Hi everyone,    I read the similar post :  https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185   However, I tried applying the suggested DAX in my Power B...
troubledlady's avatar
troubledlady
New Member
3 years ago

There are two catergories -  Account and Department. I want to calculate a difference per Account catergory between Spent and Projection. Please advise.  

 

 

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi troubledlady 

    your sample dataset is not sufficient to reflect the challenge, please consider enrich it. 

    • troubledlady's avatar
      troubledlady
      New Member
      3 years ago

      This is sample dataset. I can't show everything from my orginial dataset which contains very sensitive info.