Forum Discussion
DAX
Hi , I have a column for Quarter which shows (Q1,Q2,Q3 , Q4 and "FY" rows , and have a separate column for Year need to show the below sales result , when year= 2024 , then the sales value -1 ...
marru1982 There is no screenshot attached,If you need to work within a specific context, like a visual that filters by quarters or years, make sure your measure or calculated column is designed accordingly.
If you want to create a new column in your table:
AdjustedSales =
IF(
[Year] = 2024,
[Sales] - 1,
[Sales]
)
If you want to create a measure to use in your visuals:
AdjustedSales =
IF(
SELECTEDVALUE('Table'[Year]) = 2024,
SUM('Table'[Sales]) - 1,
SUM('Table'[Sales])
)
marru1982 Hope it works.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!