Token Right paren expected

[Anonymous]

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 )
)
))

[Gordonlilj · Accepted solution]

Hi,

It looks like you're mixing M and dax code.

Are you trying to create a calculated column or a custom column in power query?

[v-chuncz-msft · Accepted solution]

@Anonymous 

Check links below to learn more.

• Power Query M formula language
• https://dax.guide/

[Gordonlilj · Accepted solution]

Hi,

It looks like you're mixing M and dax code.

Are you trying to create a calculated column or a custom column in power query?