Forum Discussion
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:...
This is quite a tricky problem for DAX . If you don't need all the data loaded, one solution is to use power query to solve the problem. You can use a groupby step in power query and extract the maximum date and the value from the status column. If you download this summarised table you will get the information you need. Of course if you need the other data as well then this may be a problem