Forum Discussion

sewaktamang's avatar
sewaktamang
Frequent Visitor
8 years ago
Solved

% Difference between two date value

 

How to get % Change between current Week and Previous Week?
Any solution ?

Need Help
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    sewaktamang

     

    It gives me correct values

     

     

     

    Did you try this formula

     

    Column =
VAR Priorday =
    CALCULATE (
        MAX ( TableName[Week] ),
        FILTER ( ALL ( TableName ), TableName[Week] < EARLIER ( TableName[Week] ) )
    )
RETURN
    DIVIDE (
        TableName[Conversions],
        CALCULATE (
            SUM ( TableName[Conversions] ),
            FILTER ( TableName, TableName[Week] = Priorday )
        )
    )
        - 1

     

10 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    sewaktamang

     

    If your Weeks are simple dates with 7 days gap then this calculated column should work

     

    Colum =
VAR Priorday =
    PREVIOUSDAY ( TableName[Week] )
RETURN
    DIVIDE (
        TableName[Conversions],
        CALCULATE (
            SUM ( TableName[Conversions] ),
            FILTER ( TableName, TableName[Week] = Priorday )
        )
    )
        - 1
      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        Hi sewaktamang

         

        Please try with this minor modification (HIghlighted in RED below)

         

        Colum =
VAR Priorday =
    PREVIOUSDAY ( TableName[Week] )
RETURN
    DIVIDE (
        TableName[Conversions],
        CALCULATE (
            SUM ( TableName[Conversions] ),
            FILTER ( ALL ( TableName ), TableName[Week] = Priorday )
        )
    )
        - 1