I need to calculate sameperiod last year not with the calander year, but with the data that is available. Because i get the current data one month late, so when i calculate the dax formula (sameperiodlastyear) it calculates till this month last year, where the data is not right. here is my scenerio.
Current Data: June 10th. Next data is available only on 13th of June. so when i use this calculation, it takes
June2019 data to compare with April2020 so the data is not right as it calculates 2 extra month. how can i resolve this?