I need some help with a DAX solution. I have a running table that has all my stores and a date that shows sales and is connected to a calendar date table. When a store closes, it will remain in the source spreadsheet with the last transaction date. I need to be able to create a stacked bar chart that shows Active Stores (stores not closed), New stores, and stores closed for each respective month.
See attached screenshot for the life cycle of one store