Forum Discussion

Mimi_Ibrahim's avatar
Mimi_Ibrahim
Helper I
4 years ago
Solved

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

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...
Need Help
Mimi_Ibrahim's avatar
Mimi_Ibrahim
Helper I
4 years ago

Hi Anonymous ,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.