Capture datetime when status = 'Completed'

[Paf]

I have a dataset containing actions to be taken and their status:{Not Started, In progress, Delayed, Completed} and I wanted to plot the dates when these actions were completed.

For this I need to be able to get the current datetime for when a status = 'Completed', and store it in a New Measure.

This is probably a really basic problem but I'm an absolute powerBI beguinner and would be gratefull for any and all help.

Kind regards

[Ritaf1983 · Accepted solution]

Hi @Paf 
Try the measure :
Current_completed = calculate(max('yourTable'[timestamp]),
'yourTable'[status])="Completed")

If it is something else 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Uzi2019 · Accepted solution]

Hi @Paf 

Create new measure and write below dax:
Current_completed =CALCULATE(MAX('SHEET1'[DateTime]), 'SHEET1'[Status])="Completed")

I hope it may solved your problem.

[Ritaf1983 · Accepted solution]

Hi @Paf 
Try the measure :
Current_completed = calculate(max('yourTable'[timestamp]),
'yourTable'[status])="Completed")

If it is something else 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.