Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a set of data loaded incorrectly for the month of May. When data refreshed, the correct data for May was loaded. Now I have two sets of data for the month of May. How do I delete the incorrect data (~9,000 lines) and keep the correct data? I can't use the "remove duplicate" option in Power Query since the values are different. Is there an option to remove mass data in PBIX?
Scenario
Month Attribute Value
May YTD OEAT 10 (correct value)
May YTD OEAT 5 (wrong value)
Expected Value
May YTD OEAT 10
But the output in PBIX shows
May YTD OEAT 15
OEAT YTD
Can you explain more about your source data and how you have two sets of data? There needs to be something to differentiate the data (datetime? ID column?).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat
Hi,
If there is a date of download column in your dataset, then you can filter on that.