Forum Discussion

NonnaBlue's avatar
NonnaBlue
Frequent Visitor
4 years ago
Solved

Having trouble creating a filter from a date table slicer

Each record in my data has a Submitted Date, Approved Date, Not Approved Date, and Implemented Date (some will be null). I will have separate visuals that are filtered on a date range for those date...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    NonnaBlue becuase you create those as a measure and then you are adding as a column, you can change Accepted Date in Range as a measure

     

    Accepted In Date Range = If(MAX(MainTable[Accepted Date])>=[StartSelectedDate], "Yes", "No")

     

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

NonnaBlue becuase you create those as a measure and then you are adding as a column, you can change Accepted Date in Range as a measure

 

Accepted In Date Range = If(MAX(MainTable[Accepted Date])>=[StartSelectedDate], "Yes", "No")

 

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.