Great step by step explanation. In Power Query I would right click a column and select Transform to get Uppercase. It's quicker, although it's good to know M function too.
Is there a way to find two uppercase characters in a row? For example, you would want to find the values 'REd', 'RED', and 'BLue', or anything that looks like that?
Fantastica como siempre, Ruth podrías hacer un video de mapas colorepticos que muestren los valores por ejemplo de cada provincia como si se tratara de otra capa?
I love you care free you are and how proud you are when something works 🤭
Many thanks for your excellent tutorials!
Yey! And thanks for the feedback:))
Thank you for this. Helpful indeed
Wonderful and useful. Thanks for sharing functions and how it works. Would love to see more..
More Power query functions or DAX?
/Ruth
@@CurbalENi prefer power query.
Got you :)
/Ruth
Great step by step explanation. In Power Query I would right click a column and select Transform to get Uppercase. It's quicker, although it's good to know M function too.
Thanks Vida! I always forget it is there!
Happy Friday :)
/Ruth
Excellent use for the new function EXACT. I can apply this formula in many different situations.
Exactly! ;)
/Ruth
Great addition! using Text.Upper seems like introduction of "Class and methods" from OOPS to Power BI!!
OOPS? 🤔
/Ruth
@@CurbalEN object oriented programming.. like java
Ok, thanks
I am not a programmer ;)
/Ruth
@@CurbalEN neither I am, went through it some time back.remembered that.
We are on the same club then :)
/Ruth
Is there a way to find two uppercase characters in a row? For example, you would want to find the values 'REd', 'RED', and 'BLue', or anything that looks like that?
Fantastica como siempre, Ruth podrías hacer un video de mapas colorepticos que muestren los valores por ejemplo de cada provincia como si se tratara de otra capa?
Te refieres a mapas de terceros como map box?
/Ruth
@@CurbalEN Te dejo un enlace para que lo veas www.tecnicoagricola.es/mapas-espanoles-dinamicos-de-superficies-de-cultivo-por-provincias-2010/
Vale gracias , lo miro :)
/Ruth
Has visto esta serie de vídeos?
m.th-cam.com/video/Hzy1YbTjDaA/w-d-xo.html
/Ruth
If you wanted to use EXACT() on numbers, would you have to convert to text?