Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Filter of Same Column

Hi,   I need to calculate a formula wherein if I select Q1 2020 it must get divided by Q1 2019 ( previous year).  The column has values like Q12020, Q22020, Q32020 and so on. Below is an idea how ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Anonymous 

    This works on my side.

     

    and here is my sample pbix file, please try it.

     

    Could you please share your sample pbix file, there should be something wrong in other.

     

    Regards,

    Lin

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
that sounds a little confusing please share some dummy data with the result you are expecting.