Forum Discussion
Table join along with a date comparison. conditional calculation
#"Sorted Rows" = Table.Sort(#"Expanded Sellbrite Order Data",{{"Date", Order.Ascending}}),
what do you need that step for?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lbendlin
I have removed that sorting step as it might have been added when developing and testing the transformations. But removing that step does not help right now as the Source step itself is never getting back with data.
The data source is Sharepoint folder. Two tables based on different criterias are created first in PowerBI and they are fine with now issues. The above presented code is for the 3rd table which is basically a join between the first 2 tables on SKU. But the join should also be accompanied by the date between condition.
Now with small sample data files, this code was running fine but with larger number of files and data, the first step is equivalent to a cross-join as the Date between condition cannot be included together with the join.
So, I want to know how to better process this type of join with a condition in PowerBI.
Thank you!
You can only do conditional joins in Power Query. In Power BI you would need to try if TREATAS on disconnected tables is any faster.