Thanks. As you work through this, please feel free to give a shout with any questions you might have. While the DAX is quite straightforward if you have a good understanding of TREATAS, there were some wrinkles in the Power Query portion that might need some additional explanation as you work through it.
I learn new stuff on this forum every single day. And actually learned a lot working through this solution.
- Brian