Forum Discussion
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 )
)
))
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?
2 Replies
- Gordonlilj
Solution Sage
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
Community Support