DAX

[marru1982]

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 , else Sales 

Have tried using IF ELSE but no help

Need help to solve this with DAX

[v-yohua-msft]

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.

[marru1982]

thanks @v-yohua-msft  but in Quarter , there is another row for "FY " and need to use that to show sum of all quarter

[rajendraongole1]

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

[fahadqadir3]

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