Find last value based on date

[caitertotz]

I have been racking my brain for days now trying to get this to work. I have a series of data each with several dates for each month, I need my report to ONLY show me the last current date of the month selected from the slicer & corresponding values.  (i.e. I select March from my slicer, it should only show me the values for 3/25/18 56,315 - Paperless, 189,626 - Paper, 12,287 - Combo)

I need to only use one slicer for all visuals, by month. There has to be an easy way?!

[v-piga-msft · Accepted solution]

Hi @caitertotz,

You could get your expected output by the following steps.

1. Create a calculated table below to get the Week of value.

Table = VALUES(Table1[Week of ])

2. Create a measure below in the Table to filter.

selected = 
IF(SELECTEDVALUE(Table1[Week of ]) = MAXX(ALLSELECTED('Table'),[Week of ]),1,0)

3.  Put the selected measure in Visual level filters and create the visual.

In addition, you could have a reference of my test pbix file.

Hope it can help you !

Best Regards,

Cherry