Forum Discussion

Roseventura's avatar
Roseventura
Icon for Responsive Resident rankResponsive Resident
9 years ago

Need help with Cumulative (Running) Total

Help!   I'm trying to get my Cumulative LY total to work, but all I get is a YTD grand total.  I created 2 measures:  Cumulative TY and Cumulative LY.  The Cumulative TY works, but the LY one doesn...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Roseventura

 

Are TY YTD Sales and LY YTD Sales measures? If they are columns, you supposes to have aggregation function in CALCULATE().

 

Can you post the formula of LY YTD Sales? If possible, please share your .pbix file.

 

Regards,

  • Roseventura's avatar
    Roseventura
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    Simon:

     

    Here are the measures (they are not columns):

     

    LY YTD Sales = calculate(sum(PBI_Invoice_Multi[Ext Sales Amount]),
        filter(PBI_Invoice_Multi,PBI_Invoice_Multi[Formatted Inv Date]<=PBI_Invoice_Multi[TodayLastYear]))

     

    TY YTD Sales = calculate(sum(PBI_Invoice_Multi[Ext Sales Amount]),filter(PBI_Invoice_Multi,PBI_Invoice_Multi[Year]=Year(PBI_FSCAPF[Current Date])))

     

    Thanks,

    Rose