topic DAX Formula Conditional on Fiscal Year in DAX Commands and Tips

DAX Formula Conditional on Fiscal Year

PaulSB — Wed, 07 Sep 2022 15:44:13 GMT

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?

Re: DAX Formula Conditional on Fiscal Year

Adescrit — Wed, 07 Sep 2022 16:19:06 GMT

Hi PaulSB ,

Is [Basis] a measure or a column?

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

Re: DAX Formula Conditional on Fiscal Year

v-zhangti — Thu, 08 Sep 2022 06:48:57 GMT

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.

Re: DAX Formula Conditional on Fiscal Year

PaulSB — Thu, 08 Sep 2022 11:11:58 GMT

Thank You Charlotte, That does exactly what was required.

Regards,

Paul