Total Sales for same month last year

[PKGARG]

I Have Three Table 1st is Date Table,

2nd is 2016_2017 Table datewise start with 01-04-2016 to 31-03-2017. & 

3rd is 2017_2018 Table datewise start with 01-04-2017 to 30-11-2017.

Now i want to create a report :-

1. DateWise Comparison Same Date in Both Year

2. Monthwise Comparison Same Month In Both Year

3. Upto November Comparison SamePeriod in Both Year

Please Provide measure calculation

[v-jiascu-msft]

Hi @PKGARG,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft]

Hi @PKGARG,

You can try it in this file.

How to display the period of question 3 in a visual? Years?

SamePeriodLastyear =
CALCULATE (
    SUM ( '2016_2017'[Quantity] ),
    SAMEPERIODLASTYEAR ( 'Calendar'[Date] )
)

Best Regards,

Dale