Forum Discussion

gaiusgw's avatar
gaiusgw
Icon for Helper III rankHelper III
5 years ago
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...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Try to create a measure and apply it to visual level filter.

    measure = if(max(OPENDET [ORDER DATE]) in values('Date'[Date]),1,0)

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi gaiusgw 

Can you please give an example of the result you want.

Regards

Phil

  • gaiusgw's avatar
    gaiusgw
    Icon for Helper III rankHelper III
    5 years ago

    Hopefully this screenshot clear things up. I am trying to make it so that results in the invoice box are narrowed down by date range. However, the date range method I am using makes it so that dates cannot have a relationship between databases. So i am looking to plug into the code in my original post. 

     

    • gaiusgw's avatar
      gaiusgw
      Icon for Helper III rankHelper III
      5 years ago

      PhilipTreacy anymore advise on this? Thanks a lot.