Cy and Ly filtering

[manishsalanke]

Hi....team we have a scenario where we have created measures for current year and last year ,we have used these mesures

CY Sales Lacs = SUM(bi__sales[bill_amt])/ 100000  ------LY Sales Lacs = CALCULATE([CY Sales Lacs], SAMEPERIODLASTYEAR(Calender[Date]))                                                         

now the problem is that we have only 2 months of sales for current year and last year has all months data but as the measure for last year is calculating sameperiodlastyear it is showing only 2 months of data for last year where as if should show all the available months of data  ---- Following visual will explain the scenario like we have 2 month of data for the fy 23-24 and for 22-23 it has all the data but in ly sales measure it is taking only 2 month of data