Forum Discussion

Ka26's avatar
Ka26
New Member
3 years ago
Solved

If len

Hello, how can i say  if 10 signs 1 Letter and 9 Numbers or If 9 signs only numbers or blank is true, else false 
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Ka26 ,

     

    It's recommeded to add a custom column to get the results in Power Query.

                                                                                                                                                             

    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.           

     

amitchandak's avatar
amitchandak
Super User
3 years ago

Ka26 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

 

In dax you can have a column based on the need 

 

if(len(Table[column]) <10, len(Table[column]) , blank())