Forum Discussion
count events in progress steps needed
Hello all, I have a fact table and a date table, what I am trying to do is count open tickets from previous months, count new tickets for the month and count tickets that did not close. I have experi...
Hey,
I guess that one of the articles you already have been reading is this one:
http://sqljason.com/2012/11/classifying-and-solving-events-in.html
Without sample data it's very difficult to say what's not working with your formula.
I created a little PBI sample file and I adjusted your Formula to my data model and it seems to work, at least I get what I expected :-)
I assume you created a measure in your fact table and used the relevant date columns from your unrelated date table.
If my sample and the article from Jason Thomas does not help, I guess you have to create sample data, upload a file to onedrive or dropbox and share the link.
Regards
Tom
Upload your file to onedrive and share the link.