DAX Formula Conditional on Fiscal Year

[PaulSB]

I have a Calendar table with Fiscal Year column.  I'm trying to write a DAX formula to add a value to a measure according to the Fiscal Year.

Cost = IF('Calendar'[Fiscal Year] = 2020, 'Fixed'[Basis] + 20, IF('Calendar'[Fiscal Year] = 2021, 'Fixed'[Basis] + 25,100)

How can I coorect this?

[v-zhangti · Accepted solution]

Hi, @PaulSB 

If [Basis] is a measure. You can try the following methods.

Cost = 
IF (
    SELECTEDVALUE ( 'Calendar'[Fiscal Year] ) = 2020,
    'Fixed'[Basis] + 20,
    IF (
        SELECTEDVALUE ( 'Calendar'[Fiscal Year] ) = 2021,
        'Fixed'[Basis] + 25,
        100
    )
)

If [Basis] is a column. You can try the following methods.

Cost 2 = 
IF (
    SELECTEDVALUE ( 'Calendar'[Fiscal Year] ) = 2020,
    SUM('Fixed'[Basis 2]) + 20,
    IF (
        SELECTEDVALUE ( 'Calendar'[Fiscal Year] ) = 2021,
        SUM('Fixed'[Basis 2]) + 25,
        100
    )
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[PaulSB]

Thank You Charlotte,  That does exactly what was required.

Regards,

Paul

[Adescrit]

Hi @PaulSB ,

Is [Basis] a measure or a column?

Are you receiving an error message, or an incorrect result?