Thank you again!
Thank you for the time you spent on this! I see a few things in your solution I should have done. With that said, your final solution (the pivot table...
Thank you all for your replies. These are all really helpful, and very much appreciated!
Thank you Phil, that was exactly what I was hoping for!
Ah, I didn't have PP add-in turned on. Thanks for your help, again. Your patience and support have been deeply appreciated.
Please forgive the delay in responding. I had to change the data source to connect with our actual source data, at which point it lost those two colum...
I was optimistic about the PP solution initially. I had no idea how to make it work in PBI so I went back to your Excel file and removed the two table...
I really appreciate you taking the time to support this. I am building two reference tables in PBI from the Gate Scans source, (Entry and Exit). I wil...
Thanks for sending along the sample file, though unfortunately it's confused me a little. I see Query1 is the AdamS table, Entry2 has the correspondin...
Hi Catalin, I suppose it would get the job done. Though for our purposes, where ~35k = 1 month ~110k = 3 months and and ~450k = 1yr, I'm not sure a...
Thank you for your responses, so very much. I have been struggling mightily with this and I worry a great deal my current solution won't be sustain...