Forum Discussion

vivran22's avatar
vivran22
Community Champion
6 years ago
Solved

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:...
DAX
Need Help
  • vivran22's avatar
    vivran22
    Community Champion
    6 years ago

    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