Forum Discussion
Post PatronCount values for specific date or date range
Super User
Post PatronThank Ashish_Mathur this does not solve the issue that I had posted. This is just a basic distinctcount on an account number for a date unless I am missing something in your attached PBIX file.
- Ashish_Mathur
See the image in my post carefully. the result there exactly matches your desired result that you posted in your initial post.
- ryan_b_fiting
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
- Ashish_Mathur
You may face performance issues. I do not know of any alternate method.