Measure to create Sales Amount

[Anonymous]

This is about to calculate the Sales Amount,

Im using a date slicer from date to to date (1-1-2018 to 5-3-2018) and getting the sales amount for this period ,but i could not able to get the sales amount for the same period in the last year (i e.1-1-2017 to 5-3-2017).

Simply i need to create a measure to calculate the Sales Amount exactly same period of the last year of the current selection.

Can some one help me?

[v-piga-msft · Accepted solution]

Hi @Anonymous，

You could follow the steps below to get your excepted result.

1. You should create a DateTable  and create a relationship between the DateTable and Amounts table.

DateTable = CALENDARAUTO()

2.You could create the measure below to get your desired result.

lastyear_Amount =
CALCULATE (
    SUM ( Amounts[sales Amount] ),
    SAMEPERIODLASTYEAR ( 'DateTable'[Date] )
)

Then you will get the result below.

For details, you could refer to my test pbix file.

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft,

Thank you for the valuable reply.I have already applied the same logic but i got another challenge Power BI does not support the Calendar table in direct query method.