Show different columns/values in a matrix based on the date measurement on relative date slicer
My need is, when relative date measurement is selected as "Week", I want to show aggregation column as Week(no month shown), and value as Week-over-week trend(WowTrend in the screenshot) and no Month-over-month trend(MomTrend in the screenshot) value shown. And when relative date measurement is selected as "Month", I need to show aggregation column as Month(no week), and value as Month-over-month trend and no week-over-week trend value. Is it do-able? Thanks!
Thanks for your prompt reply @amitchandak ! My issue is not for calculation of WoW or MoM trend, it is how to switch the trend value, and the matrix column based on the relative date period. In other words, if user choose relative week in date slicer, the matrix aggregates on week(the data has week num column), if user choose relative month, the matrix aggregates on month(The data has month column). I showed a screenshot of what I wanna to acheive.
Red arrow shows the pair of week aggregation, and green arrow shows the pair of month aggregation as below. If relative date slicer is in week, then only red pair shows, and if relative date slicer is in month, then only green pair shows.