Forum Discussion
Solved
Compare two CRM extracts
I have two CRM extracts which each show the status of our opportunities. I've loaded both tables into Power BI one called current one called previous. I've produced a side by side comparison of t...
Thanks for all your comments, I researched some of your suggestions but nothing seemed to fit, so I came up with a workaround.
My CRM extracts where csv files, so I combined them into one table in excel, with a bit of VBA code to automate. Now it treats everythingas one table and filters work perfectly in Power BI
Ashish_Mathur
Super User
Super UserHi,
If there is a Calendar Table with a Week column in that Table, then i can help.