DAX expression - If condition

[chandni90]

Hi!
I have a table similar to the table below. I want to write a DAX expression that would do the following job - If the Time stamp is wk 22, then divide the sum of amount by 3 else keep the sum of amount as is.

Table 1:

So the result would be -
Wk 21- $50
Wk 22-  $25
current - $90

How do I achieve this? Thank you!

[Greg_Deckler · Accepted solution]

So, like this?

Measure = 

  VAR __timestamp = MAX('Table'[Timestamp])

RETURN

  IF(__timestamp = "wk 22",SUM([Amount])/3,SUM([Amount]))

[chandni90]

I got it to work. Thank you for your help!

[chandni90]

Thanks for your reply. This is the error message I am getting -



Also, there are numerous time stamps in my data and it's not the maximum week for the timestamp where I need to divide by 3, so i don't think I should be using the max function?