Forum Discussion

marcofalzone's avatar
marcofalzone
Helper I
2 years ago
Solved

Cross Check Matrix Visual

Hi Community, I have a dataset with transactions between companies. Parties (From / To) can both sell and purchase each other. Data Table (example):    The check I want to perform on the da...
Need Help
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi marcofalzone 

     

    I produced your required output of the intercompany mismatch matrix.

     

    In order to make Power BI recognize matching revenue and costs transactions recorded by as identical, I created a helper column like below.

    Then I created calculated columns to identify the mismatch.  

    I will omit details of each step, but instead, I attach the link to the pbix file below.   

    Intercompany mismatch matrix.pbix

     

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi marcofalzone 

 

I produced your required output of the intercompany mismatch matrix.

 

In order to make Power BI recognize matching revenue and costs transactions recorded by as identical, I created a helper column like below.

Then I created calculated columns to identify the mismatch.  

I will omit details of each step, but instead, I attach the link to the pbix file below.   

Intercompany mismatch matrix.pbix