Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone, I need help creating a group by the table and use it to filter my data. The table has two columns; the name of the firm and Certification type and what I would like to do is create a table or column (whatever works) that shows whenever a firm is both DBE and SBE the result should show "SBE-DBE".
Table
Firm name | Certification
Firm A | SBE
Firm B | DBE
Firm A | DBE
I would like the result to be something like this
Firm name | Certification
Firm A | SBE-DBE
Firm B | DBE
Thank you in advance 🙂
Solved! Go to Solution.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
one more question is it possible to add a third if statement with the third column?
I would like to have something like this if the firm is DBE and ESB and Active then ESB-DBE
Example
Firm name | Certification | Status
Firm A | SBE | Active
Firm B | DBE | Denied
Firm A | DBE | Active
Result
Firm name | Certification | Status
Firm A | SBE-DBE | Active
Firm B | DBE | Denied
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you very much 😊
Do you have a Dim table for Firm already?
Once you get that Firm table, relate it to the certifications table. Then you can add a column to it using DAX:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@benjellounm
Create the following table. This will summarize by Firm not only SBE-DBE but whatever multiple rows per firm.
Let me know if this works for you.
New Table =
VAR __TABLE =
SUMMARIZE(
TABLE8,
Table8[Firm name],
"CERTIFICATION",
CONCATENATEX(
DISTINCT( Table8[Certification] ),
Table8[Certification], " - "
)
)
RETURN
__TABLE
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
92 | |
87 | |
77 | |
73 | |
68 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |