Forum Discussion

dwel0120's avatar
dwel0120
Helper III
3 years ago

Trying Again: Using Latest Date in table unless date selected

On my page I have a bar chart based on number of people by dates (daily capture) and then I have a table that represents the YoY change in the number of people. In order to get the latest date to sho...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi dwel0120 ,

 

Based on your description, I recommend using the custom visual "Preselected Slicer".

Then we can create a measure.You can do this by using slicers to filter the largest dates by default.

 

Latest date =

var _maxdate = MAXX(ALL(Sample_Data),'Sample_Data'[Due Date])

return

IF(SELECTEDVALUE(Sample_Data[Due Date])=_maxdate,TRUE(),FALSE())

 

Please refer to my PBIX file.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.