Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
How can the Flex and COBRA columns be consolidated given this data?:
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!
Solved! Go to Solution.
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
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
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |