Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

'Same Store' Utilzation

Hi guys, I'd like to see the growth of 'same store' volume (same store = not including new customers)   I have the following Table Data: CUST SAP Number RunYearMonth C17 Volume 111 2020M...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , move year to different table say date (This will work when the year is in the different table only

 

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

    I'm getting an error with the last year one for some reason..

    Any Clue?

    Many thanks