Forum Discussion

nickvb's avatar
nickvb
Frequent Visitor
6 years ago

Same Store YTD Calculation

I am hoping for some assistance in creating a YTD same store growth calculation.  The goal is to see how stores are growing that were open in both the prior and current year.    The dax calculation...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi nickvb ,

 

 

here because there is no data given i'm using 'table' and some column names. Please replace them with the actuals ones.

 

Please use the below formula :

 

SAME PERIOD LAST YEAR  = 
VAR DataMaxDate =
    CALCULATE ( MAX ( 'Table'[Date.Date].[Date] ), ALL ('Table' ) )
RETURN
    CALCULATE (
        [YTD Sales],
        SAMEPERIODLASTYEAR (
            INTERSECT (
                VALUES ('Table'[Date.Date].[Date] ),
                DATESBETWEEN ( 'Table'[Date.Date], BLANK (), DataMaxDate )
            )
        )
    )

 

 

 

NOTE : make sure to change Date column to date type otherwise you will end up with the same issue you are facing.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.

 

Regards,

Gaurav Raj Singh

LinkedIN : https://www.linkedin.com/in/gauravrajsingh/

View solution in original post