how cumulative totals help in any Business analysis? pls adv.
@LearnDAX2 күн бұрын
@@charithavani2783 There are usually fluctuations in sales daily, weekly, monthly. A cumulative sum helps us understand how the sales have accumulated over a period be it days or a set period of days or weeks instead of simply observing the total sales that happened in a month or quarter or year. This way business can get a better sense of the numbers! Hope that helps 😊
@charithavani2783Күн бұрын
@@LearnDAX oky...got it. Thank u
@charithavani27834 күн бұрын
Hide option in selection pane is not working. pls Adv.
@charithavani27834 күн бұрын
I got it
@deepakbhandari93545 күн бұрын
Great Presentation
@LearnDAX2 күн бұрын
Thank You 😊
@deepakbhandari93546 күн бұрын
Very nicely presented.
@LearnDAX6 күн бұрын
Thanks a lot!
@deepakbhandari93549 күн бұрын
Excellent going.
@LearnDAX9 күн бұрын
Thanks a lot!
@sayedraeespeer10 күн бұрын
lo brother subscribe kar diya🙂
@LearnDAX10 күн бұрын
Thank You 😊
@deepakbhandari935411 күн бұрын
Excellent presentation
@LearnDAX11 күн бұрын
Thank You 😊
@aditi589714 күн бұрын
Thank you for this 💯
@LearnDAX14 күн бұрын
I'm Glad you found the Video Series Helpful! Happy Learning 😊
@meeradhumne468514 күн бұрын
Thank you for another’s well explained video
@LearnDAX14 күн бұрын
Thank You 😊
@vloggingwithmichael763516 күн бұрын
Thanks
@LearnDAX16 күн бұрын
You're Welcome 😊
@vloggingwithmichael763516 күн бұрын
Thanks! Your tutorial helps me a lot to learn powerBI. Now I understand the logic.
@LearnDAX16 күн бұрын
I am Happy that you found the Video Helpful! Thank You 😊
@charithavani278316 күн бұрын
Wov .... as usual I watched all your videos...Your Business problems are really mind tickling. Thanks for sharing your knowledge. Looking forward for more such videos.
@LearnDAX16 күн бұрын
I feel Grateful after reading your comment! I will work towards making more such Videos! Thank You 😊
@charithavani278319 күн бұрын
v nicely explained , your logic is v good , Need more n more business problems
@LearnDAX19 күн бұрын
@@charithavani2783 Thank You So Much! I will try to make more Videos! Happy Learning 😊
@Foodie-Techie20 күн бұрын
Question 6 was a tricky one but indeed a good one.
@LearnDAX19 күн бұрын
@@Foodie-Techie I'm Glad you enjoyed the Questions! Happy Learning 😊
@Abhijeet-bp6um20 күн бұрын
Getting this error msg for " summarise " Function "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
@LearnDAX20 күн бұрын
@@Abhijeet-bp6um It could happen if we use Summarise function inside a Measure, Can you try using it in a New Table? Should Work 😊
@Abhijeet-bp6um20 күн бұрын
@@LearnDAX Got same error Sir
@LearnDAX20 күн бұрын
@@Abhijeet-bp6um Ok using New Table under Modeling tab also giving the same error?
@Abhijeet-bp6um20 күн бұрын
@@LearnDAX Problem Solved, tried one more time in modeling tab. Thank You sir😀
@LearnDAX20 күн бұрын
@@Abhijeet-bp6um Oh! Great! You are getting better at troubleshooting too ☺Happy Learning!
@deepakbhandari935422 күн бұрын
Great going
@LearnDAX22 күн бұрын
@@deepakbhandari9354 Thank You 😊
@ceyhunozturk511526 күн бұрын
Thank you! Can you please dataset?
@LearnDAX26 күн бұрын
Thank You for Watching the Video! Dataset and DAX Queries docs.google.com/spreadsheets/d/1jntr8x6ddBngNDE4gw2ldRslrrFRAnSMSa7fK3MRUvQ/edit?usp=sharing The DAX Queries used can be found in the above link, also if you want to learn about how the queries were created you can refer to the below playlist link - End to End DAX Project Business Problems Playlist kzbin.info/aero/PLxtoMrpa5HO9MPd32wzob12vuGlSrw7gp Again! Thanks for Watching! Happy Learning 😊
@Sirigineedi_Navann28 күн бұрын
You are doing an wonderful series brother ❤️
@LearnDAX28 күн бұрын
Thank You! These words of encouragement really give me the motivation to keep trying! Happy Learning...
@huyuc661428 күн бұрын
After watching your part 1 and part 2. You love using the summarize table + topn to identify top 1 or top 5 ^^. Nice way
@LearnDAX28 күн бұрын
I am so Glad that you liked it! I am as much a learner, learning about DAX and Power BI from experimentation! Happy Learning!
@charithavani2783Ай бұрын
V well explained with example. Thank u
@LearnDAXАй бұрын
@@charithavani2783 I'm Glad that you found value from this Video! Happy Learning!
@sourabhpatel3834Ай бұрын
Voice is too low
@LearnDAXАй бұрын
Apologies for that. I will try to ensure such issues don't occur in my future Videos.
@RamzanRajaniАй бұрын
Nice explanation of getting Top 5 using Topn & Summarize function
@LearnDAXАй бұрын
Thank You 😊 I'm Glad you found my way of explaining concepts Useful!
@samuelvaraprasad1172Ай бұрын
I've seen all your videos. content is gold. Please add more videos related to DAX only. also best resources to learn dax end to end. Thanks a ton.
@LearnDAXАй бұрын
Thank You for your Kind Words! Yes will keep making more videos and mention resources which can help learn DAX ! Happy Learning 😊
@Sirigineedi_NavannАй бұрын
Simply marvellous brother 👌👌
@LearnDAXАй бұрын
I'm Happy that you are Enjoying the Videos 😊
@krishnaRaog21Ай бұрын
Great work
@LearnDAXАй бұрын
@@krishnaRaog21 Thank You 😊
@meeradhumne4685Ай бұрын
Very well explained
@LearnDAXАй бұрын
@@meeradhumne4685 Thank You 😊
@meeradhumne4685Ай бұрын
Nicely done!!
@LearnDAXАй бұрын
@@meeradhumne4685 Thank You 😊
@Sirigineedi_NavannАй бұрын
One of the best series 😊 Thanku so much brother ❤
@LearnDAXАй бұрын
I am Glad you Liked the Video 😊Happy Learning!
@MusicalShorts-hn1pxАй бұрын
This is exactly, was looking for. Please keep posting more such DAX videos and business problems.
@LearnDAXАй бұрын
@@MusicalShorts-hn1px I'm Happy you found the Video Helpful! Sure I will try to create more such Videos 😊
@sourabhpatel3834Ай бұрын
Without Variable also it will give same result.... The only difference is that max is calculated on current context (i.e it will give you the same row on which you are running)
@LearnDAXАй бұрын
Yes, that's Right, different ways to get to the same solution 😊
@ing.luisfernandoortizmaldo1029Ай бұрын
Great video. Thanks for share, greetings from Colombia!
@LearnDAXАй бұрын
@@ing.luisfernandoortizmaldo1029 Thank You! Glad that you found the video helpful ! Greetings from India
@MusicalShorts-hn1pxАй бұрын
Recording a video even on Birthday takes sheer determination...Wish you a great year ahead, Cheers!
@LearnDAXАй бұрын
Thank You! I am just happy that I can do the thing that I Enjoy, on my Birthday!
@MusicalShorts-hn1pxАй бұрын
Keep up the good work !
@LearnDAXАй бұрын
Thank You! I am glad you found the Video Helpful 😊
@LearnDAXАй бұрын
Good Day Everyone! I have added the Dataset in the Description so you can practice along with the video... Happy Learning!
@LearnDAXАй бұрын
Good Day Everyone! I have added the Dataset in the Description so you can practice along with the video... Happy Learning!
@LearnDAXАй бұрын
Good Day Everyone! I have added the Dataset in the Description so you can practice along with the video... Happy Learning!
@rafiullahkhan5543Ай бұрын
Can u share the data set so we can practice along with thank you
@LearnDAXАй бұрын
Thank You for the Feedback! I will update the same in the Description and provide the dataset! Happy Learning!
@LearnDAXАй бұрын
Good Day! I have uploaded the Dataset, do let me know if you are not able to access it. Happy Learning !
@rafiullahkhan5543Ай бұрын
@@LearnDAX Thanks alot U r very cooperative and ur videos r very informative. I hope we can have a small talk sometime when u get free.
@RajeshKumar-qwweeАй бұрын
After so much time 😅
@LearnDAXАй бұрын
Yes Sir! Took a Long time Indeed... 😅
@nsulikow2 ай бұрын
Nice approach using Excel to explain it. However, I don't think there is a context transition in your example. Context transition occurs when the row context is "transitioned" into the filter context. In your example, you only have row context. This is my understanding. Thanks for the video anyway.
@LearnDAX2 ай бұрын
Hey, Thank You for your Inputs! I will try to take a look and study the concept more deeply so I can teach better 😄
@koushikchoudhury21793 ай бұрын
Excellent.Kindly make a complete tutorial for PBI-- Sratch to Pro
@LearnDAX3 ай бұрын
Thank you so much for your feedback, I am working on it, and will soon upload more content!
@vijayarana20873 ай бұрын
Superb
@LearnDAX3 ай бұрын
Thank you so much!
@rajatsehgal42494 ай бұрын
What is on-premise in this context : Power BI gateway is a component that connects Power BI desktop and Power BI service, allowing access to on-premise data within secured networks.
@LearnDAX4 ай бұрын
On Premise can be your Local Laptop in this case. For example you create a report, you will store it in your Hard drive, this is what we call On Prem
@rajatsehgal42494 ай бұрын
@@LearnDAXAnd also on-premise can be third party server.
@rajatsehgal42495 ай бұрын
I have downloaded the SQL server , but when moved towards the installation setup it is showing error. I have tried this couple of times, but unable to install. Is this problem occuring because my laptop is old?
@Vishal_195 ай бұрын
Nice Videos, can you please provide the dataset as well
@LearnDAX5 ай бұрын
Thank You for your feedback 😊 I will work on the same and update !
@takasisrinu90075 ай бұрын
Wow ..what a explanation..plz continue
@ragulmarley49005 ай бұрын
Really nice do more videos begin to advanced
@LearnDAX5 ай бұрын
I'm Glad you found it Helpful! Will Try to Make more Videos! Thank You 😊
@rajatsehgal42495 ай бұрын
In Power BI desktop in the data pane , I had the date column which was initially in text data type, but I successfully changed it to date data type. But still in Power query when I'm changing to date data type it is showing error in some rows.
@LearnDAX5 ай бұрын
Is the Error showing up for all dates, or is it for only some of the dates? Did you first change the data type in Power Query or in Data Pane? Ideally you would make all the changes with regards to formatting the data type within Power Query, Close and Apply and then use them in Visuals! I hope this gives you some direction 😊
@rajatsehgal42495 ай бұрын
@@LearnDAX Initially I was making changes in power query only regarding the date data type ,but it was showing an error in some rows. Then I converted the text data type into date data type in the data pane. to
@rajatsehgal42495 ай бұрын
@@LearnDAX It is showing errors for some of the dates in Power Query. And the dates present in date column is in this format - 26-10-2023. Initially I changed the date data type in Power Query only. However since it was showing an error, I changed date data type in the Data Pane.
@monubhaiya90225 ай бұрын
Thanks sir much needed
@rajatsehgal42495 ай бұрын
When I asked this to chatgpt it answered - COUNT function counts the number of numeric values in a column. It ignores non-numeric values, including blanks and text. Does COUNT function excludes string or text data type?
@LearnDAX5 ай бұрын
The way I would try to understand is by creating a column which contains 5 numerical values, 5 text/string values and 5 blank values and use the Count function on this column, and the Output will give me an exact answer as to which values are considered or ignored by the Count function! Hope this gives you some perspective 😊... Happy Learning
@rajatsehgal42495 ай бұрын
@@LearnDAX It is showing 15 . It means it is including text , numerical as well as blank values.
@LearnDAX5 ай бұрын
Well, my earlier reply was just a way to start exploring the function, we should also refer to DAX documentation on Microsoft website, and then play around by changing the inputs to the function, this is how I also keep learning! learn.microsoft.com/en-us/dax/count-function-dax Hope this helps you to find the answer and get confident in exploring functions by Trial and Error 😊
@rajatsehgal42495 ай бұрын
@@LearnDAX Yeah that's an in depth way to learn and apply the DAX functions.