Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create a table that shows every row that has a numeric value previous to the one selected in slicer

I have a table like this:

 

I want to make a slicer so it shows me only this when I select a value. For example, if I select 6, I should only see this:

 

 

My DAX code is something like this

 

Previous_month_table = FILTER(ALLSELECTED(table), table[mes]) = SELECTEDVALUE(mes[month]) -1)

But this is not working.

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try like

    Previous_month_table = FILTER(ALL(table), table[mes]) = SELECTEDVALUE(mes[month]) -1)

     

    In such case Mes begin an independent table can work better, in that case, you can avoid all

    Previous_month_table = FILTER((table), table[mes]) = SELECTEDVALUE(mes[month]) -1)