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

amitchandak's avatar
amitchandak
Super User
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