Forum Discussion
Solved
Power Challenge
Hello everyone, I hope you are all well. I'm developing a project that I need to track the progress of my activities. The connection to my database takes place in real time directly from Ms planner,...
Hi FrankWoodyblue ,
I think you may have to use R/Python to export data as snapshot of historical data when the data source is refreshed.
Schedule Automated Data Exports from Power BI using a simple R/Python Script
Best Regards,
Winniz
Hi FrankWoody ,
Please use DAX to create a new table.
newtable2 =
UNION ( Table2, FILTER ( Table1, NOT Table1[task] IN VALUES ( Table2[task] ) ) )Test results:
After updating the data source, Table 1:
Table 2:
newtable 2:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.