Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Date picker

Hi,   My input dataset is as follows:   The date picker will show all the dates. Based ont he dates I choose fromt he date picker, the table will have last 4 months from the selected date d...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous I would recommend using relative date filter function, like show last 4 months etc.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi parry2k ,

     

    I've now edited my post.. Sorry 

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      Anonymous my reply is the same, use relative date filter, much easier to work with otherwise you have to create disconnected table for slicer and then work with measures, etc, can be achieved but seems overkill when relative date filter can achieve the same goal.

       

      I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        My output table is a MATRIX and I need to sort it by descending order, I'm not sure how I can do this by relative filtering