how to get data for maximum date in date slicer?

[Anonymous]

I have a date slicer in my report, i want data for some visuals related to the maximum date selected in range from date slicer. I cannot see any option to have data on that specific date. Right now, for all visuals it is taking cummulative data of whole date range selected. How to achieve this?

[Anonymous]

How can we filter dataset in powerbi using this maxDate?

[vicky_]

To get the maximum date selected in the slicer, use the DAX 

maxDate = CALCULATE(MAX(Table[Date]), ALLSELECTED(Table[Date])), which you can use directly as a filter on the visual if there is a relationship, or as a filter argument.