Forum Discussion
Find last value based on date
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?!
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 !:smileytongue:
Best Regards,
Cherry
1 Reply
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 !:smileytongue:
Best Regards,
Cherry