Forum Discussion

Pricey79's avatar
Pricey79
Helper V
5 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    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.

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

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.