Forum Discussion
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 ...
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
Thanks for the prompt response but I have already taken care of the space. I am getting infinity value using this formula.
v-lili6-msft
Community Support
Community SupportHI Anonymous
Getting infinity value means there is no value for last year for same quarter by this formula,
MFelix's formula should work, Please check if data is right, for example, filter Q12020 and Q12019 together to see if there is data in Q12019.
If you still have the problem, please share a simple sample pbix file, that will be a great help.
Regards,
Lin