Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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 |
---|---|
10 | |
8 | |
5 | |
5 | |
4 |