Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
Tutorial Requests
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous

 

Could you please post some sample data and expected result as well?

 

Thanks
Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the reply, the table below is counting new tickets submitted, I need to add two measures, I need to count tickets carried over from previous months and tickets that did not close during the month. I have a Submitted date and a closed date in the table.