I am trying to get the current quarter vs Previous Year Quarter numbers in Power BI. It is working fine for all the quarters, but the problem is with the total of last year vs a total of the current year.
In my calculation, we have only a quarter-time period in the date table. Below is the formula used.
I have created a quarter count column and based on the quarter count minus -4 in the calculate function.
Please help how to calculate the FY total no. of current year vs. Previous Year.