Thank you very much, Ruth, for helping me to understand DAX. These videos are so helpful and I just want you to know how much I appreciate the time you take to help us all. You're the best!!❤❤
Hi Ruth, thanks for your video. Question: Is it better to create variables then standalone measures (measures which won't be used anywhere else)? Looking in advance for your feedback. Thanks
Mil gracias Ruth por tus vídeos, son fundamentales para aprender Power Bi. Una pregunta, ¿podemos utilizar variables ya creadas en otra medida diferente? Gracias!!
Thank you Ruth for brilliant videos, for every DAX question, your videos helping me as a dictionary. Please can I request you to provide the demo file for this video? currently its not available in DAX Fridays Zip folder.
Very helpful video Ruth. Like you mentioned in this video, can you please provide the link to how to write a DAX in a proper format which is easily readable. I know most write DAX is a continuous line & do not arrange or format it accordingly.
Hi Ruth, Can you please clarify when to use VAR inside a formula/ expression (VAR is declared before CALCULATE or after it) or outside it. I understand this creates lots of confusion and can impact the numbers integrity.
Thank you Ruth, can you please help on , how can I use a Measure in a DAX formula? For example... Column 2= CONTAINSSTRING(Table1[Column1],[Measure]) if I use this it will show TRUE regardless if Column1 contains or not the [Measure], the way arround I came up with is an NON INTERACTIVE alternative is to use the text this means Column 2= CONTAINSSTRING(Table1[Column1],"A") this works fine but is not Interactive. Thanks for sharing your knowledge
Im exercising what I learn from you in this video, again tank you, still Not working in what Im trying to do, for example: Condition2 = VAR Texto = [Measure 2] RETURN CONCATENATE(Texto,1) Unfortunately the result is 1, what I'm expecting is to see is "what ever is in Measure 2 1" Thanks for your help
Hi Ruth. My code is now looking professional. Is there any performance gain, by combining multiple separate measures into one single measure (with these separate measures defined as variables)? I want to get into good habits 😄
Que gran tips haz dato sobre las formulas de tiempo, aqui estoy averiguando y ejercitando tienen el medio potencial, gracias Ruth ademas de potenciarlas con las variables VAR. Saludos desde Chile ,from end the world.
Great video - do you think it's worth having 1 measure into which you store all your variables so that if you need to go looking for them they are all in 1 place?
+DataSpinners Hi Dataspinners, it sounds like a good idea, have you tried it? I know some people creaste tables to store all measures, so why not? Have a great weekend! /Ruth
Hi Ruth, thanks for the Video! I am new in PBI and DAX, and kind of got lost in the formula you have used. No need for a new video or such, Just write a few words in the reply of what is happening after the DATESBETWEEN Syntax.. any feedback from your other followers are welcome too. Many Thanks in Advance
Gracias, Ruth! You're GOD-SENT! I enjoy how you explain the logic behind your videos which is sometimes missing from most videos.
😊
Thank you very much, Ruth, for helping me to understand DAX. These videos are so helpful and I just want you to know how much I appreciate the time you take to help us all. You're the best!!❤❤
And thanks to you for taking the time to tell me ❤❤
/Ruth
Excelente Ruth. No solo es mas ordenado sino buena estrategia para el uso mas efectivo de la fórmula
+Julio Bolivar Gracias Julio! 😊
/Ruth
Thank you, Ruth for making us understand the usage in various aspects and application of the function.
My pleasure :)
/Ruth
Hi Ruth, thanks for your video. Question: Is it better to create variables then standalone measures (measures which won't be used anywhere else)? Looking in advance for your feedback. Thanks
Mil gracias Ruth por tus vídeos, son fundamentales para aprender Power Bi. Una pregunta, ¿podemos utilizar variables ya creadas en otra medida diferente? Gracias!!
Hola Almudena,
Desafortunadamente, no es posible. :(
/Ruth
Thank you Ruth for brilliant videos, for every DAX question, your videos helping me as a dictionary.
Please can I request you to provide the demo file for this video? currently its not available in DAX Fridays Zip folder.
If it is not there, then I dont have it :(
/Ruth
Thanks for all of your videos. I have been using them (especially the DAX Fridays) to learn PowerBI.
You welcome!! Really happy they are useful:)
/Ruth
Could I choose a date to get the number of contracts that are in effect (I mean they started before and ended later)?
Gosh!! gracias Ruth! tienes las soluciones a mis problemas de todos los dias !!! you r the best!!
Jajaja ah si? Pues me alegro!
Buen día
/Ruth
jaja si en serio, soy adicto a tu canal jajaja
🔥🔥🔥
/Ruth
Thanks for showing just how easy Variables can be!
You welcome!!
/Ruth
Very helpful video Ruth. Like you mentioned in this video, can you please provide the link to how to write a DAX in a proper format which is easily readable. I know most write DAX is a continuous line & do not arrange or format it accordingly.
Great video Ruth, is a easy form to ordered the house.
Great Job!!
Hi Ruth, Can you please clarify when to use VAR inside a formula/ expression (VAR is declared before CALCULATE or after it) or outside it. I understand this creates lots of confusion and can impact the numbers integrity.
Thank you Ruth, can you please help on , how can I use a Measure in a DAX formula? For example... Column 2= CONTAINSSTRING(Table1[Column1],[Measure]) if I use this it will show TRUE regardless if Column1 contains or not the [Measure], the way arround I came up with is an NON INTERACTIVE alternative is to use the text this means Column 2= CONTAINSSTRING(Table1[Column1],"A") this works fine but is not Interactive. Thanks for sharing your knowledge
Im exercising what I learn from you in this video, again tank you, still Not working in what Im trying to do, for example:
Condition2 = VAR Texto = [Measure 2]
RETURN
CONCATENATE(Texto,1)
Unfortunately the result is 1, what I'm expecting is to see is "what ever is in Measure 2 1"
Thanks for your help
Awesome explanation!! thank you PBI Wonder Woman!!!
Hi Ruth. My code is now looking professional. Is there any performance gain, by combining multiple separate measures into one single measure (with these separate measures defined as variables)? I want to get into good habits 😄
+bridgemasterx Great question! I am planing to do a performance video in a few weeks, I will make sure to touch your question.
/Ruth
Thanks Ruth. Will look forward to this.
+bridgemasterx Perfect!
Que gran tips haz dato sobre las formulas de tiempo, aqui estoy averiguando y ejercitando tienen el medio potencial, gracias Ruth ademas de potenciarlas con las variables VAR. Saludos desde Chile ,from end the world.
Saludos Eladio!
/Ruth
Great video - do you think it's worth having 1 measure into which you store all your variables so that if you need to go looking for them they are all in 1 place?
+DataSpinners Hi Dataspinners, it sounds like a good idea, have you tried it?
I know some people creaste tables to store all measures, so why not?
Have a great weekend!
/Ruth
You cannot refer to a variable which is created in another measure.
+Birdzhan Myumyun True, don't know where I pick that from ....
Hi Ruth, thanks for the Video! I am new in PBI and DAX, and kind of got lost in the formula you have used. No need for a new video or such, Just write a few words in the reply of what is happening after the DATESBETWEEN Syntax.. any feedback from your other followers are welcome too. Many Thanks in Advance
Could u share more Videos on VAR?
Sure , anything you are thinking of?
/Ruth
Thanks for this
Can we use variable inside a variable?
Yes, you should be able to:
docs.microsoft.com/en-us/dax/var-dax
/Ruth
Thanks 😊
Very helpfull - thank you
+Mark Blackburn You welcome!
/Ruth