Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
4 years ago

Date change query

Hello   I was hoping someone could help please   I have a calculated column that changes to yes or no depending on the values of other columns. Is it possible to get the date of which the calcula...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Pricey79 ,

 

According to your statement, I know that you have ABC1 and ABC2 in ABC, the status of ABC is based on ABC1 and ABC2, only both of them return "Yes", the status of ABC will return "Yes".

Now you may meet this situation, Category A, ABC1 may show "Yes" and ABC2 show "No". If ABC2 show "Yes" after refresh, you want to get the last modified date of ABC2.

We only could get last refresh date by DateTime.LocalNow() in Power Query. This function will show the last refresh datetime in all fields. However we may have this situation, Category B,both ABC1 and ABC2 has shown "Yes" before this refresh. But it will still show last refresh datetime instead of keep the datetime before. Then you will be confused whether this category is modified after this refresh. 

So I think Power BI now doesn't support you to achieve this.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.