Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

Difference in previous week

i have a table with a total snapshot on friday e.g 100. what dax would i need to show the increase or decrease from previous friday.    
Need Help
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    Hello there NewbieJono ! Imagining you are adding up the values for a column the Dax would be as follows:

     

    Total_value =
CALCULATE(
SUM(Table[Column]),
DATEADD(Date_Table[Date_Column], -7, DAY)
)

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes

speedramps's avatar
speedramps
Super User
4 years ago

Try this ...

Variance % =

VAR salesthisweek =
SUM(Query[Sale])

VAR salespreviousweek =
CALCULATE(SUM(Query[Sale]),
DATEADD(Query[Date],-7,DAY)
)

RETURN
DIVIDE(salespreviousweek , salesthisweek)