Forum Discussion
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
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.
2 Replies
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())
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.
