Forum Discussion
vivran22
6 years agoCommunity Champion
Measure Help: Conditional Count
Dear Community Members, Need your help in the following: I have a dataset: Task ID Timestamp Status ABC 2/2/2020 4:45 To-Do ABC 2/12/2020 23:52 Planned ABC 3/5/2020 16:...
- 6 years ago
Anonymous
6 years agoNot applicable
vivran22
6 years agoCommunity Champion
Hey Anonymous
Thank you for your response.
The solution you have provided is quite intuitive but the constraint is that there cannot be any support table, nor I can use Power Query. I was running out of options hence looking for expert's advise.
Solution provided by Ashish_Mathur worked on the sample dataset, but didn't work on complete dataset.
Please advise if there is any other alternative.
Cheers!
Vivek
https://www.vivran.in/
Connect on LinkedIn