Forum Discussion

marru1982's avatar
marru1982
Frequent Visitor
2 years ago

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 ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    marru1982
    Frequent Visitor
    2 years ago

    thanks Anonymous  but in Quarter , there is another row for "FY " and need to use that to show sum of all quarter