Display Last N Values when selected Slicer

Question

I need a matrix that display the last 6 MonthYear when selected. The formula gives me the totals by column and not by row and I need them.Can you help me with the formula below to give me too the totals by row.Note: I´ve created a secondary calendar (Presentation Calendar) to help me with the formula.Focusedlast6Months=&nbsp;&nbsp;&nbsp;&nbsp;VAR&nbsp;CurrentDate&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MAX&nbsp;(&nbsp;'DIM&nbsp;Calendar'[date]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;VAR&nbsp;PreviousDate&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EOMONTH&nbsp;(&nbsp;CurrentDate,&nbsp;-6&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;VAR&nbsp;Result&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HASONEVALUE&nbsp;(&nbsp;'Presentation&nbsp;Calendar'[MONTH_YEAR]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;MAX&nbsp;(&nbsp;'Presentation&nbsp;Calendar'[Date]&nbsp;)&nbsp;&lt;=&nbsp;CurrentDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;MIN&nbsp;(&nbsp;'Presentation&nbsp;Calendar'[Date]&nbsp;)&nbsp;&gt;&nbsp;PreviousDate,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'OVERALL&amp;INTERACTIONS'[%&nbsp;Focused&nbsp;Average],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;'DIM&nbsp;Calendar'[MONTH_YEAR]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'DIM&nbsp;Calendar'[MONTH_YEAR]&nbsp;=&nbsp;VALUES&nbsp;(&nbsp;'Presentation&nbsp;Calendar'[MONTH_YEAR]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BLANK&nbsp;()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ResultThank you

amitchandak · Answer

rmeng , refer my video, when select one date/period, how to disply more than one date/period 
https://youtu.be/44fGGmg9fHI?list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L

rmeng · Answer

Thanks for the video I´ve watched and created a formula, but still don´t work, April shouldn´t be there. If I select March 2021 the month year to be display should be Mar2021, Feb2021,Jan2021, Dec2020, Nov2020, Oct2020.

This is my formula but still don´t work:

Last 6 Months =

Var MaxDate = MAXX(ALLSELECTED('Presentation Calendar'),'Presentation Calendar'[DATE])

Var MinDate = DATE(YEAR(MaxDate),MONTH(MaxDate)-6,DAY(MaxDate))

Return

CALCULATE( [% Focused Average],FILTER('DIM CALENDAR', 'DIM CALENDAR'[DATE] <= MaxDate && 'DIM CALENDAR'[DATE] >= MinDate))

Forum Discussion

Display Last N Values when selected Slicer

2 Replies

Related content

Display Selected and not selected values

Display slicer values selected in card

Display text with selected values

Display selected slicer values(multiselect)

Display selected filter on this visual value per individual graph.