Forum Discussion
Helper VDate change query
Community ChampionHi Pricey79
You can create another Calculated Column to provide you with the output your after using an IF statement:
Yes Date = IF ( 'Table'[Yes or No Column] = "Yes" , 'Table'[Date] , BLANK() )
Hope this helps 🙂
Theo
- Pricey79
TheoC Thank you for your reply, but what date would I put here?
"Yes" , 'Table'[Date] , BLANK() )
The two fields that feed the Yes/No column come from an external database that I do not control. I dont know if that helps you or not though.
- TheoC
Hi Pricey79
Do you have visibility of when the dates were changed? If not, and running off what lbendlinhas raised, how frequently is the data refreshed?
The challenge you will have is that you'd need to maintain all records historically and combine them in a source given that a change from No to Yes may occur for every record (theoretically).
I apologise as I was under the incorrect impression that there was a Date column in your records to provide the context. If not, it has the potential to become a bit messy.
Apologies again!
Theo
- Pricey79
Thank you and apologies for not being clearer in the original post.
The external data source will contain on average 50-100 records at once, the whole pbix is refreshed 4 times a day. Out of the 50-100 records, around 5-10 will change from no to yes on a daily basis. What I'm after is to show when the record changed to yes, to show when it was ready for the next part of the chain.
Hope that makes more sense!
