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 IV"Keep Order as the main table and do left join with the customer table."
So after the merge step, my next two steps would be to expand columns and then filter to remove nulls (ones that didn't match anything in my customer list)?
Hello,
Instead of removing NULL, the replace them as a separate category, it will make sense for the end user to view them as Non-Catagorized and for you also it will help to match the figures.
Thanks.
- CmdrKeene
Roger, 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: