User Profile
jeroenwmwillems
Advocate I
Joined 7 years ago
User Widgets
Contributions
Re: Days between orders of Unique Customers
Thanks heaps for this Ashish, this did exactly what I asked. I discovered I made a mistake in my logic however, as I am actually trying to see how many days it took for a customer to order again after a certain event. Therefore, my end result should ideally look like this: Would there be a way of tweaking the fomula to get this as a result? Thanks again for your help!Days between orders of Unique Customers
Hi there, I'm getting stuck with a query and haven't been able to find any answers in previous posts from other users. Effectively, I have 2 columns of interest: Date and UserID. I'm trying to calculate the amount of days in between consequtive orders for the individual users. I've made a screenshot of an example file with column 3, days between orders, the desired column to make. (In my actual data, these values are of course not perfectly fitlered like this). Thanks in advance for your wisdom! Cheers, JeroenReflecting an excel table into PowerBI
Hi all! Hope you can help a brother out: I'm looking for a super basic solution. We export our P&Ls of independant business monthly into a sheet and combine them manually into one. It looks very simple: First column is revenue accounts, cost accounts, etc. The following columns show the months and $ numbers. I would like to show the table we have in excel in PowerBI. As an MVP: Is there a way to just get PowerBI to show the same table as already present in excel without feeding any other underlying data. Litteraly, just the actual table should be copied (almost like an image). And more intelligently: any ideas how I could do the combining of the P&Ls of the two companies in PowerBI while still only exporting the P&Ls from Xero into sheets? Let me know if anything is too vague and more info is needed, thanks in advance! Cheers, JeroenHelp in first occurance based on three columns
Hi all, Hope you can share your wisdom with me and help me set up a column query for the following: I'm trying to create a colum that tags the first visit of a user to a location. I have a date column, a location column and a user column. What formula would I have to write up to get the output as in my screenshot? Thanks in advance for your help on this one!
