topic Re: Calculate sum Revenue for the same fiscal Period last year in DAX Commands and Tips

Calculate sum Revenue for the same fiscal Period last year

rafajammali — Wed, 15 Apr 2020 15:42:39 GMT

I have a period(1,2,3,4,5,6,7,8,9,10,11,12) slicer and year(2018,2019,2020) and will like to calculate the sum of revenue for last year for the same Period that the user pick Vs the Revenue this year for that period.

Now using sameperiodaslast year function won't work because I am using fiscal periods and the start date/end date of the same period is not the same.

If i use year -1 it gets me the result I am looking for but when I select all periods it does a full year vs this year revenue stops at todays number.

Any idea how to stop last year revenue in the same day as today -1 year.

Re: Calculate sum Revenue for the same fiscal Period last year

Greg_Deckler — Wed, 15 Apr 2020 17:44:11 GMT

I'm not sure of the issue you are describing in your third paragraph. Can you post sample data, the results you are getting and the results you want instead?

Re: Calculate sum Revenue for the same fiscal Period last year

Anonymous — Wed, 15 Apr 2020 18:58:10 GMT

Do you number the days within each fiscal period? Do these periods have the same number of days?

Best
D