Jeff,

that's basically what I did. (it's like a mini star schema, and Calendar is just a dimension table). Turns out, I used your calendar table-valued function. =) ... so I have a bunch of stuff in the table that's persisted so that it's easy to report on.

The interesting part was that PowerBI let me declare some variables, get the earliest and latest dates in my table, and generate the Calendar on the fly... but creating the table in M was waaay more than I wanted to do. I did read Chris Webb's blog and some other stuff, but seems like a huge hassle... Might try it again when I get my head around M a little better.

Pieter