Forum Discussion

jjvelasco's avatar
jjvelasco
New Member
10 years ago

Accumulated Sales

Hello, Thank you in advance for time I have a base where they have been stored sales since 2012 until today, now that we have our license powerbi, we want to make a comparative where we make the cum...
achinm45's avatar
achinm45
Icon for Advocate IV rankAdvocate IV
10 years ago

Hi,

Can you create two measures :

1) Measure M1 =  TotalYtd(Sum(Sales),Date_Columns)

2) Measure M2_Previous =  Calculate(SUM(Sales),SAMEPERIODLASTYEAR(Date_Column))

 

And when you bring them both on table and slice by date , you may compare this year sales and last year sales.

 

BR,

Achin

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Since you are doing YTD - change CALCULATE(SUM(Sales),... to CALCULATE([Measure M1], ... in the 2nd Measure

     

    if you have Year and Months in the rows of a Matrix

    the second measure will not show you Previous YearToDate but just Previous Year just for each Month

     

    Hope this makes sence - test it in a Matrix with Year and Month on the rows and you'll see what I mean.

     

    YTD is running total.