Forum Discussion
DataFunness
Helper I
Helper IFilter Matrix on Percent Change
Hello, I am trying to take only records that have a percent change where the percent change is above 50% or below -50%. It isn’t comparing year to date sales to sales year to date last year. The ask...
parry2k
Super User
Super UserDataFunness your model needs improvement but for now, you can do this, not sure why you have a summary calendar table, see attached:
DataFunnessHelper I
Helper IThank you parry2k .
I think I'm getting close. Two things:
- There are other filters that I needed, so this is how I added them (yellow highlight)
- But I'm not sure how to filter for the dates I need. Eage page has its own calendar and the summary page had its own calendar. Where can I add the calendar I need filtered:
- 'Calendar Mkt Shr'[Year] = selectedYear
- 'Calendar Mkt Shr'[Month] = selectedMonth
Thank you again,
Matt