Forum Discussion
Solved
How do I do this in PBI?
HI, I'm trying to create this report in PBI. In SQL, it would look like this: I loaded my dataset as TEST2 but I can only generate the TripCount per month summary. I created a table [Trip...
So I created the MIN MAX table:
On my Summary Table, I added a range column that is linked to the MIN MAX table:
On my Martrix:
or PIVOT
Thanks 2 all!
See attached PBIX.
Most of the work done in PowerQuery but you could move this upstream to SQL.
Not quite but almost there. The Matrix wasn't matching on the range count but the totals are correct.
VS
Your approach did give me an idea. I moved the dataset to SQL and pulled it in (since I needed to deliver the report due to time constraints). Thank you.