Forum Discussion

NB3's avatar
NB3
Helper III
7 years ago

Automatic filter a specific data month by month

Hi everyone,

 

I'm not sure my title really describes what I need but it's tough to explain in couple words,

 

Here is the thing, I have a spreadsheet with monthly data (0 = inactive ; 1= inactive). I want to know how I can create an automatic filter that will get all 0 in Feb and 1 in March (see screenshot). To determine who was not active in Feb and is in March.

 

Then it'd have to do the exact same thing with the next months (all 0 in March and all 1 in April and so on)

 

 

Thanks,

 

Nick

Need Help

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, NB3 

    According to my knowledge, I'm afraid that it couldn't achieve in power bi for now.

    You need to add a flag column that compares two columns and use it to filter data manually. Then use the same logic for other columns.

     

    Best Regards,

    Lin

    • NB3's avatar
      NB3
      Helper III
      7 years ago

      v-lili6-msft 

       

      Thank you for your answer, I'll try that and see if it works,

       

      Nick,