Filtered measures across date ranges using a many-to-many relationship with dates
Hi there, Following on from the post regarding filtering inventory on a dashboard, I was able to create a pre-calculated date value for each row in the main inventory model, allowing for single-sel...
Using a duplicated column for both the date range and the column we wish to compare. Then applying the appropriate filtered measure to both - was missing that part.