Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to compare two dataset with different granularity?

Hi all,   hope you are well!   I am struggling to compare the two dataset Platform1 and Platform2. I would like to compare impressions and clicks of Platform1 and Platform2, however this is what ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    You need to create dimension tables for fields common to both tables, As in:

     

    You then use the dimension tbales in visuals, filters, measures, slicers...

     I've attached the sample PBIX file

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

You need to create dimension tables for fields common to both tables, As in:

 

You then use the dimension tbales in visuals, filters, measures, slicers...

 I've attached the sample PBIX file

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you so much for your help! 🙂