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.
Need some help on grid calculations. Given the matrix below, how can I retrieve values that have a positive count in both 2022 and 2023 (Crowdstrike both DEN and DGN = 1, Crowe DGN = 1, ICA = 0, Data Storage DGN = 0):
Sample data below.
Id | Name | Group | Date |
abc123 | Data Storage Corporation | DGN | 2022 |
abc124 | Dajani Consulting Inc. | ICA | 2023 |
abc125 | Dajani Consulting Inc. | ICA | 2022 |
abc126 | Datadog Inc | ICA | 2023 |
abc127 | Crowe LLP | ICA | 2022 |
abc128 | CrowdStrike Inc | DEN | 2022 |
abc129 | CrowdStrike Inc | DEN | 2023 |
abc130 | Crown Castle International Corp. | DEN | 2023 |
abc131 | Crown Castle International Corp. | DEN | 2022 |
abc132 | Crown Castle International Corp. | DGN | 2023 |
abc133 | Crown Castle International Corp. | DGN | 2022 |
abc134 | Datadog Inc | DGN | 2022 |
abc135 | Data.World | DGN | 2022 |
abc136 | CrowdStrike Inc | DGN | 2022 |
abc137 | CrowdStrike Inc | DGN | 2023 |
abc138 | Crowe LLP | DGN | 2023 |
abc139 | Crowe LLP | DGN | 2022 |
Solved! Go to Solution.
Found the answer using variables:
Found the answer using variables:
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |