Forum Discussion

RoydenC's avatar
RoydenC
New Member
3 years ago
Solved

Data Profile: Min and Max Text Length

Hello I am currently profiling my data using the Table.Profile() function and it's working. My issue is that I also need it to provide me the min and max length of the text in the data.   This work...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    3 years ago

    You need to create a List of the lengths in order to apply the LIst.Min or List.Max functions

     

    profile = Table.Profile(#"Table to Profile", {
        {"Max Text Length", each Type.Is(_, type nullable text), each List.Max(List.Transform(_, each Text.Length(_)))},
        {"Min Text Length", each Type.Is(_, type nullable text), each List.Min(List.Transform(_, each Text.Length(_)))}
        })

     

     

     

ronrsnfld's avatar
ronrsnfld
Super User
3 years ago

You need to create a List of the lengths in order to apply the LIst.Min or List.Max functions

 

profile = Table.Profile(#"Table to Profile", {
        {"Max Text Length", each Type.Is(_, type nullable text), each List.Max(List.Transform(_, each Text.Length(_)))},
        {"Min Text Length", each Type.Is(_, type nullable text), each List.Min(List.Transform(_, each Text.Length(_)))}
        })

 

 

 

  • RoydenC's avatar
    RoydenC
    New Member
    3 years ago

    Thank you for taking the time to post the solution and an explanation. It worked wonderfully. Much appreciated!