DAX

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!!

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!! 

Hi, marru1982 

I create a sample table:

Then create a calculated column and use the following dax:

NewSalesColumn = 
IF (
    'Table'[Year] = 2024,
    'Table'[Sales] - 1,
    'Table'[Sales]
)

Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.