Forum Discussion
Count values for specific date or date range
Hi Community - I am looking to count values on a specific date / date range. I have two tables. Date_Table and Admissions Table that are joined on Date / Admission_Date. Admissions Table is as ...
Ok, I see it now in Power Query.
When I apply the in Power Query and try to refresh my data I get an OLE DB ODBC Error 'Increment' argument is out of range. My data is from salesforce, once I get this error figured out, I have one other questio: how scalable is this solution? My table already has 40k+ rows and some with stays 30 days or more? Creating multiple lines for each unique stay seems like this is going to cause performance issues sooner rather than later
You may face performance issues. I do not know of any alternate method.
Thank you for the responses. The output gives me exactly what I want, but the performance is way to slow to use for end users.