Forum Discussion

PKGARG's avatar
PKGARG
Icon for Helper I rankHelper I
8 years ago

Total Sales for same month last year

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 ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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] )
)

Total_Sales_for_same_month_last_year

 

Best Regards,

Dale