Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am new to Power BI and have the following use case with me:
I want to combine the 2 data sources in the following way:
Hope the use-case makes sense. Highly appreciate any help on this.
Solved! Go to Solution.
@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
Is your issue solved?
If the issue has been solved, please adopt the solution to help others.
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!
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!
@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
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |