Data Load from Azure Synapse using list.max doesn't work

[Mimi_Ibrahim]

Hi All

I have below formula embedded in my PBIX file to restrict by 2 months worth of data. It works fine when the data loads from Cloudera Impala. However, it doesn't work when the connection is repointed to Azure Synapse- basically the data loads everything when I click refresh. Anyone can help? Thank you.

#"Filtered Rows" = Table.SelectRows(Table,
each ([calmonth] = List.Max(Table[calmonth]) or [calmonth] = List.Max(Table[calmonth])-1)),
#"Kept Errors" = Table.SelectRowsWithErrors(#"Filtered Rows")
in
#"Kept Errors"

[v-stephen-msft · Accepted solution]

 Hi @Mimi_Ibrahim ,

Please check this similar post:

Solved: Error When Using Power Query to Restrict Data - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mimi_Ibrahim]

Hi @v-stephen-msft ,

The link you provided is from my other post which is a different issue. This post if for different issue. 

[v-stephen-msft · Accepted solution]

Hi @Mimi_Ibrahim ,

Try the following.

= Table.SelectRows(#"Changed Type", each [calmonth] = List.Max(#"Changed Type"[calmonth]) or [calmonth] = List.Max(#"Changed Type"[calmonth])-1 )

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-stephen-msft · Accepted solution]

 Hi @Mimi_Ibrahim ,

Please check this similar post:

Solved: Error When Using Power Query to Restrict Data - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.