DAX Fridays! #92: Write DAX even faster with this amazing keyboard shortcuts!

[@gustavoleo8946]

Fantastic! I l love the way you teach! Congrats! Cheers!

[@CurbalEN]

Oh thanks!! 😊 And happy Friday!! /Ruth

[@charliemather3368]

Great job explaining, Ruth. Truly time saving tips. Note that if you have enabled the hotkeys for the Intel HD Graphics Control Panel, you will get some surprises using the CTRL-ALT-UP and CTRL-ALT-DOWN keys. The screen orientation will flip up or down!!! Strongly suggest you disable the hotkeys for your graphics display if you think you will needing those key combos in DAX.

[@CurbalEN]

That is a great tip! Thanks for sharing! /Ruth

[@andriskriekis6486]

Thanks Ruth. I didn’t even know that there are such shortcuts at all. So it is really fantastic. Thanks.

[@CurbalEN]

Hi Andris! Me either to be honest, I knew just a few! Have a great weekend and say hi to everybody:) /Ruth

[@mehdihammadi6145]

Hi Ruth and thank you for sharing because most all the shortcuts were new for me. Regarding the shortcuts a thing I learned few years ago, and I always teach to my attendees, is that they can be differents from a langage version of an app to another. So actually I use a french version of the BPI Desktop with a french keyboard setting and these shorcuts worked for me "CTRL+:" to comment, "CTRL+^" to right indent and "CTRL+)" to left indent. So maybe you can add a new column "Hotkey3" to your report

[@CurbalEN]

Definitely! Thanks for sharing:))) /Ruth

[@vida1719]

Very useful shortcuts. Another one thing is to remember them.

[@CurbalEN]

Ohhh I agree! I am going to do my best to mention them when I write DAX in future videos, but it is going to be tough as I don’t have the habit myself yet.. I will do my best! /Ruth

[@NorbertoVeraReatigaNVR]

Bastante útil!!! gracias Ruth por esta excelente búsqueda de tips para facilitarnos el trabajo... aunque confieso que ahora escribo pocas fórmulas desde la inclusión de las medidas rápidas en Power BI!

[@CurbalEN]

Si? Yo no le usado desde que lo introdujeron. Tengo que probar de nuevo! Gracias por el tip! /Ruth

[@devinsolkov5101]

Really helpful video!

[@eladiobardelli3001]

Hola Ruth , en que área trabajas mas común con power bi ( contabilidad,finanzas,logística,ventas,recursos humanos ) y podrías hacer algún vídeo sobre API, saludos desde Chile, gracias por todo.

[@CurbalEN]

A esta alturas, ya he hecho projectors en casi todo!! Quieres un vídeo del APi de Power BI? /Ruth

[@HachiAdachi]

Thank you sooo much for sharing, Ruth! I had NO idea there were so many keyboard shortcuts! I love them all! I can't seem to be able to download your pbix file, though?

[@CurbalEN]

Ahhh! Fun to see you are as excited as I am!!! What error are you getting? /Ruth

[@HachiAdachi]

I'm getting "de4.gofile.me didn’t send any data."...

[@CurbalEN]

Weird... it works for me. Are you in a corporate environment? /Ruth

[@HachiAdachi]

I'm actually home today. If nobody else is having an issue, it's probably on my end. No worries, your video explained everything very well!

[@CurbalEN]

Let me move it to my onedrive and post the link again. /Ruth

[@francodutto2287]

Hola Ruth! Muy bueno los videos! Te hago un consulta, tengo dos tablas una la de calendario y en otra los registros de cada asesor en el cual se tiene una columna con el DNI otra la cantidad de horas por jornada , otra en la que se indica desde que fecha trabaja y la otra hasta cual. Si yo en la tabla de calendario genero la siguiente columna calculada: CALCULATE(SUMX(Registro_HsTeoricas;Registro_HsTeoricas[Cantidad de Hs]);FILTER(Registro_HsTeoricas;'Date'[Date]>=Registro_HsTeoricas[Fecha Incio ]&&'Date'[Date]

[@CurbalEN]

Hola Franco, Podrías poner la pregunta en la comunidad de Power Bi? Pon ejemplos de tus tablas. Puedes ponerlo en español sin problemas! /Ruth

[@francodutto2287]

Genial, haré eso! Muchas Gracias! ;)

[@vineetyoutubr5]

Wow Ruth.. this one is really amazing video but we need to practice atleast for a week 😛

[@CurbalEN]

Only a week? I am thinking I will have to practice for at least a month!! 😉 Happy Friday! /Ruth

[@gaid81]

Thanks x millions

[@CurbalEN]

My pleasure :)

[@josepromero1452]

Fantastic Tip nº 9!! --> The end of delete and / or backspace!!! About download the file, this is the error that appears for me: Es posible que la página web de4gofile.re.cs.quickconnect.to/2kEOD/sharing/cVi81Zur0?tunnel=/tunnel/ esté temporalmente inactiva o que se haya trasladado definitivamente a otra dirección. Thank you for sharing!!! Josep

[@CurbalEN]

Ahhhhh! I need to change the download service 😬