Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filtered rows in power bi

I need to show the data inside a table, based on the year filter.

I need to check two conditions based on the selected year.

Need to check selected year greater than closing year and less than due year.

Is it possible, please help 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Try to refer to my .pbix file.

    You only need to add the measure that meet the filter criteria to the table visual to complete the filter.
    Note: My condition is greater than or equal to and less than or equal to.

     

    Best regards,
    Lionel Chen

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Assuming year is coming from an independent year table,

     

    A new measure like

     

    calculate([measure], filter(table, year(table[closing date]) <= selectedValue(Year[year]) && year(table[due date]) >= selectedValue(Year[year])))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak , but my scenario is different, need to display rows based on the above condition.

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        Try to refer to my .pbix file.

        You only need to add the measure that meet the filter criteria to the table visual to complete the filter.
        Note: My condition is greater than or equal to and less than or equal to.

         

        Best regards,
        Lionel Chen

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