Forum Discussion
Pricey79
5 years agoHelper V
Status Change Help Please
Hello, I was hoping someone could help me please. I have a column called Status of which the data comes from a dataflow, of which I dont have access to control/change. Is there a way in power BI...
- 5 years ago
Pricey79 ,
a new column
= if([Status]= "Approved", [Date], blank())
a new measure
maxx(filter(Table[Status]= "Approved"), [Date])
USe measure with id or something for which you are looking for status change
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
mohammedadnant
5 years agoImpactful Individual
Hi Pricey79
If you want to know when the status changed to "Approved" then there must be a date column in the dataflow to track the changes. pls check for this
Thanks & Regards,
Mohammed Adnan
Learn Power platform from TAIK18 <-- click on the name