Forum Discussion
DAX expression - If condition
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!
So, like this?
Measure =
VAR __timestamp = MAX('Table'[Timestamp])
RETURN
IF(__timestamp = "wk 22",SUM([Amount])/3,SUM([Amount]))
3 Replies
- Greg_Deckler
Community Champion
So, like this?
Measure =
VAR __timestamp = MAX('Table'[Timestamp])
RETURN
IF(__timestamp = "wk 22",SUM([Amount])/3,SUM([Amount]))