Forum Discussion

Jos13's avatar
Jos13
Helper III
6 years ago
Solved

Week over Week Sales Growth

Hi Team, I have a data set in the following format.   I have created a measure to calculate daily growth as follows Daily growth% =     VAR __PREV_day = CALCULATE([Sales], DATEADD('DateT...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Jos13,

    You can try to use following link if it meets your requirement:

    Weekly growth% =
VAR currDate =
    MAX ( 'DateTable'[Date] )
VAR _curr =
    CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALLSELECTED ( Table ),
            YEAR ( [Date] ) = YEAR ( currDate )
                && WEEKNUM ( [Date] ) = WEEKNUM ( currDate )
        )
    )
VAR _prev =
    CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALLSELECTED ( Table ),
            IF (
                WEEKNUM ( currDate ) > 1,
                YEAR ( [Date] ) = YEAR ( currDate )
                    && WEEKNUM ( [Date] ) = WEEKNUM ( currDate ),
                YEAR ( [Date] )
                    = YEAR ( currDate ) - 1
                    && WEEKNUM ( [Date] )
                        = WEEKNUM ( DATE ( YEAR ( currDate ) - 1, 12, 31 ) )
            )
        )
    )
RETURN
    DIVIDE ( _curr - _prev, _prev )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Jos13,

You can try to use following link if it meets your requirement:

Weekly growth% =
VAR currDate =
    MAX ( 'DateTable'[Date] )
VAR _curr =
    CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALLSELECTED ( Table ),
            YEAR ( [Date] ) = YEAR ( currDate )
                && WEEKNUM ( [Date] ) = WEEKNUM ( currDate )
        )
    )
VAR _prev =
    CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALLSELECTED ( Table ),
            IF (
                WEEKNUM ( currDate ) > 1,
                YEAR ( [Date] ) = YEAR ( currDate )
                    && WEEKNUM ( [Date] ) = WEEKNUM ( currDate ),
                YEAR ( [Date] )
                    = YEAR ( currDate ) - 1
                    && WEEKNUM ( [Date] )
                        = WEEKNUM ( DATE ( YEAR ( currDate ) - 1, 12, 31 ) )
            )
        )
    )
RETURN
    DIVIDE ( _curr - _prev, _prev )

Regards,

Xiaoxin Sheng