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

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

One question - the same formula is not working in my PBI because the column Qtr_FY is a calculated one not just the imported column?

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    hi  Anonymous 

    I don't think this is problem that cause your error, if possible, share a simple sample pbix file, that will be a great help.

     

    Regards,

    Lin

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    The fact that yuou use a calculated column should not be an issue, and based on the information you are giving the calculation should be correct, can you share the MRR values so I can check it out. As describe in my previous answers and on the example given by v-lili6-msft  the formula is working however this can be a problem with your model and canb e related with data format, filtering or some other context that can influence your measure.