Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Pricey79
Helper V
Helper 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 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. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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.

View solution in original post

5 REPLIES 5
mohammedadnant
Impactful Individual
Impactful 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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!

Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18
amitchandak
Super User
Super User

@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.

@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 

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.

@v-xiaotang thank you for your reply 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.