Previous month selected with interval

Question

Hi Could someone help me with the below&nbsp;I have a slice filter where I have my Month-Year field from my calendar table&nbsp;&nbsp;I need to have a measure in which I should capture a column field related to the previous month.For example, in the case above it should return Apr 23 - Total Session Value (here the it's correct)&nbsp;THE PROBLEM: is that if I unselected Apr 23 from the slicer filter I expect that the value returned should be from Mar 23, but it keeps returning the value from Apr 23....I need that the returned value "Total Sessions last Month" should be 70881&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp;jimi123&nbsp;,
&nbsp;
I created a sample file for your reference.
Sample data:

There's no relationship between the main table and the calendar table.

&nbsp;
Create a measure for the visual-level filters.
Measure = 
var _select=SELECTCOLUMNS('Calendar',"1",'Calendar'[MonthYear])
var _date1=
MAXX(
    FILTER(ALL('Calendar'),'Calendar'[MonthYear] in _select),[Date])
var _datecolumn=
SELECTCOLUMNS(
    FILTER(ALL('Calendar'),'Calendar'[MonthYear] in _select&amp;&amp;YEAR(MAX('Table'[Date]))=YEAR(_date1)&amp;&amp;MONTH(MAX('Table'[Date]))&lt;&gt;MONTH(_date1)),"1",[Date])
return
IF(ISFILTERED('Calendar'[MonthYear]),IF(
    MAX('Table'[Date]) in _datecolumn,1,0),1)
Put the measure into the Filters and set up show items when the value is 1.

Here's the result.

&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;&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;&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;&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;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Previous month selected with interval

2 Replies

Related content

Interval Previous Date

Previous month selected automatically from drop-down slicer

Diff between selected and previous period

Selected Year and Previous Year

Scheduling a Microsoft Fabric Pipeline with Specific Time Intervals