Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sales Analysis Report

HI All

I need help to develop sales report with figures comparision Actual sales / previous sales and Target.

Thanks and regards
Sudharsan

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Sudharsan,

     

    Can you share a dummy sample and the details of your requirements? You can try these time intelligence functions like dax/previousmonth-function-dax.

     

    Actual Sales = sum('sales'[amount])
    Previous Sales =
CALCULATE ( SUM ( 'sales'[amount] ), PREVIOUSMONTH ( 'calenar'[date] ) )

     

    Best Regards,