The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Community,
I have two columns that have the following categories:
Station | Scene Station |
52 | 52 |
63 | 63 |
61 | 61 |
24 | 24 |
11 | 11 |
103 | 103 |
Mutual Aid | |
12C | |
blanks | blanks |
When I sum the count distict of my incident ID for each category, I get the following distribution:
I would like to substract the count district of incident ID for 'Station' by count district of incident ID for ' Scene Station', would anyone know how to do this?
Thank you for the help,
Denisse
User | Count |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |