Forum Discussion

utkarshaggarwal's avatar
utkarshaggarwal
New Member
5 years ago
Solved

Client vs Peer Comparison

Hi,   I am new to Power BI and have the following use case with me:   I have 2 data sources (in Excel) Source A has the data for a client for n number of criteria (Industry, Employees count, Re...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    utkarshaggarwal , Create a common dimension, which has the client name from A and Peer name from B

    called peer group, If need add a new column as client name in source A

     

    distinct(union(distinct(source[Client_name]), distinct(source[peer_name])))

     

    Now using this you can analyze them together

     

    if you want to select peer using a slicer, then you might need independent tables.

    refer date example

    How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi utkarshaggarwal

 

The two tables need to have common columns and create relationships that can then achieve your expected output as:

 

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!