Forum Discussion
count events in progress steps needed
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
Yes I looked at the article and many more. I am fairly new at this and can't really grasp a starting point.
What is the best way to share my.pbix? SharePoint Online One Drive?
It has 8084 rows
Upload your file to onedrive and share the link.
Hey,
maybe you can't use onedrive because sharing content with external users (outside your organization) is disabled by your O365 admin, please check if you have this option available
Maybe you have to consider to use your personal onedrive or dropbox.
Regards
Tom
I don't have those options. I will check the other methods.