Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |