Forum Discussion
Keeping data based on export date and unique occurrences
Hello everyone, I have to create a report via Power Query which has a technical difficulty that I seem incapable to work around. The ERP we use flushes data more than 6 months old, so for example...
Hi Spigaw ,
Is there a Flag column that show each anomalies 's status(fixed or flushed )?
As Vijay_A_Verma said, based on the logic you described, the output should be D and E only.
Please kindly refer to
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We have no way of tagging the anomalies. I'll try to find a manual way to fix this, thanks for your help!