The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi - I have a column where an incident was opened, and a column where the incident was closed. I am trying to count the number of incidents open for a given month (i.e. Open as of 1/31/2023 - closed as of 1/31/2023). Could anyone please point me in the correct direction to solve this?
I was able to create a column in a separate table to calculate the value, however, I need it in the same table so slicers will work.
Thanks!
Hi @rando1901 provide some sample data and expected output.
Proud to be a Super User!
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |