Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Token Right paren expected

On using below formulas as caluclated column, throwing error as Right Paren expected. Pls check and provide solution asap.

 

= Table.AddColumn(#"Changed Type", "Custom", each if (
MONTH (MAXDATE1[MaxDate]) = 05
and CEILING ( DAY ( MAXDATE / 7 ), 1 )
< CALCULATE (
MAX ( Query1[MaxNumOfPayWeeksInMonth] ),
FILTER ( Query1, Query1[MONTH] = 01/2019 )
),
CALCULATE (
SUM ( Query1[MID_MONTH_NET_AMOUNT] ),
FILTER ( Query1, Query1[MONTH] = 01/2019 and Query1[WeekNum] = "<=2" )
),
CALCULATE (
SUM ( Query1[MTD_NET_AMOUNT] ),
FILTER ( Query1, Query1[MONTH] = 01/2019 )
)
))