Forum Discussion
Helper IVWhat Join is More Performant?
Hello,
Keep Order as the main table and do left join with the customer table.
Do not use filter date in the query, rather use slicer to filter date after importing the complete data, you can use DAX function for previous year comparison. While importing data with 8 million rows it may take around 45 minutes.
Later use gateway to auotmate the data refresh.
Do not change the order date to start of the month, create new column based on the existing column-order date.
Do not use grouping, from the visualziations you will be able to group the data by customer.
Thanks.
Helper IVRoger, thanks for your guidance. I'm actually trying to use the "get data" formerly power query tools in Excel to grab some data for a one-off report, not a dashboard. I'm nto sure if there's a better place to ask questions for that specifically, but the query editor is nearly the same and regardless you helped me get my work done.
Glad to know that it was helpful:smileyhappy: