I am trying to get the amount where the MOD( 'Calendar'[Fiscal Week num],13 ) = 0 )
Otherwise, the amount of 'Calendar'[get_current_week] = "Yes"
. How to bug the code below? many thanks in advance.
Amt3 =
VAR Amt1 =
CALCULATE(
[measure],
FILTER('Calendar', MOD( 'Calendar'[Fiscal Week num],13 ) = 0 ))
VAR Amt2 =
CALCULATE(
[measure],
FILTER('Calendar', 'Calendar'[get_current_week] = "Yes" ) )
Return IF( ( MOD( 'Calendar'[Fiscal Week num],13 ) <> 0 && 'Calendar'[get_current_week] = "Yes" ) ,Amt2, Amt3 )
Where get_current_week
is a calculated column
get_current_week = IF(
AND(
WEEKNUM(TODAY()) = WEEKNUM('Date'[Date]),
YEAR(TODAY()) = YEAR('Date'[Date])
),
"Yes",
"No"
)