- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 desktop for me to add when the Status column changes to a particular status?
So for example, I would like to know the date that the status was changed to Approved
Thank you in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@amitchandak Thank you for taking the time to reply
Sorry, what Date field should go here? = if([Status]= "Approved", [Date], blank())
I get a red squiggly line under the word date
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Pricey79
if the dataflow has column [Status] & [Date] both, then you can use the Dax expression mentioned by amit. otherwise it will show a red line under [Date] because the dataflow doesn't have this column.
Perhaps you need to contact the owner of the dataset to add the date column in dataflow.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 05-15-2024 06:43 PM | ||
04-19-2024 08:50 AM | |||
07-10-2024 08:53 AM | |||
03-21-2023 08:53 PM | |||
09-03-2024 03:24 PM |
User | Count |
---|---|
137 | |
107 | |
84 | |
59 | |
46 |