Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
Solved! Go to 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.
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.
Hi @v-stephen-msft ,
The link you provided is from my other post which is a different issue. This post if for different issue.
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.
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.