Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Measure to create Sales Amount

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...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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.