Events.xlsx (297.6 KB)
I have this file (attached) that shows dates when events were opened or closed. I am trying to create two correspondent measures:
- one to show how many events were opened in a certain month;
- another to show how many events were closed in a certain month.
The result that I am looking for is similar to the manual solution on top of the sheet (range F1:T3 ).
There is no luck, using DAX. The solution I was thinking of fell flat. The manual one works wonders.
Any help would be appreciated.