Forum Discussion
Creating a Matrix with Row and Column headers based on dynamic date calculation
Hi all, I am attempting to make a matrix which would allow a user to select two dates and it would show the annual recurring revenue (ARR) bucket for the first date in the rows and for the second...
You can’t use calculates columns because they don’t recalculate based on slicers. My hunch is you will need to use a technique like I show here => Measures on rows in Power BI. You could create 2 disconnected tables, one to feed columns and one to feed rows. You would then have to harvest the values from the intersection of row and column to do a calculation on a measure.