Dynamic Comparison based on Year,Quarter and Month

DAX DAX Calculations
21

Hello @timilk,

I will not be setting up the filter of Month year or anything. Just the one filter that is created with the help of a static table. So, I want to you whether this will work in such a case?

Also, please share the file and I can verify the solution.

Thanks
Shubham

22

Fixed the upload. Yeah you might be right @skathuria My solution is more about the contextual previous Period calculation. Hopefully it offers some ideas as this solution should work with any type of date filter.

Also just an idea but instead of using Month Year in My example you could pass it the output of the filter in @Harsh example. e.g. Month slicer = 1, Quarter = 3, Year = 12