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 ...
Hi marru1982 - you can try below calculation to get the expected result using if clause
Modified Sales Value =
IF(
[Year] = 2024 && [Quarter] <> "FY",
[Sales] - 1,
[Sales]
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!