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

     

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
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi sewaktamang

 

My apologies.

 

Please use this formula

 

This will get you correct results

 

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