Forum Discussion
Solved
DAX Formula Conditional on Fiscal Year
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]...
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.
v-zhangti
Community Support
Community SupportHi, 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.
Thank You Charlotte, That does exactly what was required.
Regards,
Paul
