Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Consolidation

How can the Flex and COBRA columns be consolidated given this data?:

1.PNG 

Rather than trying to calculate things for each and every combination of names, I just need a single column that will give me all of each person's data regardless of the type of manager they are. Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @v-yulgu-msft , the answer to the solution can be found here:

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Situation/m-p/420900#M193486

 

The user posted 2 options and the option that I'm implementing on my report is #1

View solution in original post

4 REPLIES 4
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

Based on current description, it is not clear about your requirement. Is above sample table the original dataset? Or the values shown above has been aggregated?

 

What is your desired result? How to calculate for each and every combination of names? Which column represents type of manager?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yulgu-msft I've since then figured out the answer to my own problem. Thank you for reaching out!

Hi @Anonymous,

 

Glad to hear that you have resolved it by yourself. Would you please kindly share your solution so that it can benefit more users?

 

Thanks,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yulgu-msft , the answer to the solution can be found here:

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Situation/m-p/420900#M193486

 

The user posted 2 options and the option that I'm implementing on my report is #1

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors