Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Week over Week % Change

  I'm tracking how many emails we send out every week. I want to display the change WoW as a percentage. I have tried to use the measure from the post here: Week over Week Change. But it only return...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, 

    I created a table with similar data and copied the measure from your post, it works fine.




    If you specify how your data is different from the table I created maybe we can find the issue

    **I did change the 'Return' part to:

    RETURN
    IF (lastWeekAmount=0,"N/A",
    DIVIDE ( SUM( 'Email data'[Emails sent] ) - lastWeekAmount, lastWeekAmount, 0 )
    )

    so that weeks that come after a week with no sales, return "N/A".

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

I created a table with similar data and copied the measure from your post, it works fine.




If you specify how your data is different from the table I created maybe we can find the issue

**I did change the 'Return' part to:

RETURN
IF (lastWeekAmount=0,"N/A",
DIVIDE ( SUM( 'Email data'[Emails sent] ) - lastWeekAmount, lastWeekAmount, 0 )
)

so that weeks that come after a week with no sales, return "N/A".