Forum Discussion
Solved
Return unique value list from date range slicer
I have used the method descibed in this link to do date range comparisons for sales but now I need to return a list based on the code. https://medium.com/chandakamit/power-bi-comparing-data-acro...
Try to create a measure and apply it to visual level filter.
measure = if(max(OPENDET [ORDER DATE]) in values('Date'[Date]),1,0)
Try to create a measure and apply it to visual level filter.
measure = if(max(OPENDET [ORDER DATE]) in values('Date'[Date]),1,0)
Sorry i do not see how this plugs into my original formula. I have tried a few differetn ways but am only getting the max value which is the most recent date. What i need is to have the results of the table narrowed by the date slicer from the original formula because many other elements of my report are linked to those date slicers.