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.
Hi, I would like to get the count of rows for column A when column B, which is year is 2019
i.e.
Do you have 1 table or 2 tables?
If you have 1, the count won't work because you are referring to 2 tables.
If you have 2 tables, you need a relationship set up correctly between them.
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |