วีดีโอ

3 years later and u just saved my ass for my Accounting 657 data analytics course 😂

Absolutely good worth making subscription

Awesome explaination and approach... Thanks buddy

Excellent video!

This was so helpful, thank you. I'll be subscribing.

❤Thank you so much sir, great method

where is code?

Thank you!

Awesome, thank you very much!

Fantastic, thanks.! Avoid the the mistake I made, and be sure to Create the duplicate Query (Sales Data (2)in this example) before creating the index columns and list. If you don't, and make the copy during the 2nd part of the video, you'll end up getting INDEX already exists errors after you Invoke the Function in the 2 part of this video.

THANK YOU

It will not work for January month

How I can do it for bottom 3

Wow Great Video Sir.

Hi, do we need to again create cardinality of measure table with other table or it will catch automatically?

Is there a way to make this dynamically calculate based on a date/week commencing/month column in a date table?

How can i do running total of distinct counting of rows. From multiple data sources? From a folder source, i have 3 excel files with same information but data is updated and rows are increasing gradually in each file. How to know the amount of increased data in each file?

Thank you so much. You are the one that explained it the easiest way to

How it will work if current month is january and you are applying year = today

amazing❗

brilliant

sir i am like born baby ......in any language please first you explain the code what it will do then..........

I did the above question in this way, Please have a look on it sir, WITH cte AS( select EID , ENAME , EDEPT , ESAL , MAX(esal) OVER(PARTITION BY edept) as max_sal from emp_sal ) select EID , ENAME ,EDEPT , ESAL from cte WHERE esal = max_sal ORDER BY ESAL;

Awesome explanation 👍Thanks for this video. Please bring more questions on sql

Thanks a lot!! 👍

How to get this data in my BI system Can u attach the data file in Description

Thank You!

Thank you so much!!!!!!!!!

Thank bro

PLEASE provide data set

Thanks so much

It's good video... I am trying to creat multiple date sheets it's work but not supposed to creat sheet what I am looking example 1/1/24 but it's crate sheet 1 can please help me why it's doing like this I am trying to do creat 262 sheet for they entire working day and creat sheet 262 to sheet 1 instead of date

Searching a simple solution for long time for this problem, today got it... thankssssss

Great Explanation ,thank you

Nice Point in learning path......

Create a dashboard using same please

Thank you. Very easy to follow.

there is an inbuilt Power Query function that does this. Table.TransformColumnNames ( #"Promoted Headers", Text.Trim ) I also like to precede it with Table.TransformColumnNames ( #"Promoted Headers", Text.Clean)

Thank you. Its Solved.... But is there any other option to get header change...?

Thank you for this video

Great video. Would this be considered intermediate or advanced question/sql querying skills?

Hi, I'm unable to do it on a brand, sub brand, master brand, category basis. Its showing 1.00 only.

Hi sir, I have Attrition which I have formatted into a negative also hiring and Net I want to show the Attrition on the bar but on the left side like there is a loss in your chart Would it be possible?

Thought I had to do a self join for this and then concatenate two columns. This saves me so much time - thanks :)

Hello I have a question about BI and I would appreciate your help. I have a table with 5 columns in order to calculate inventory per day. I can transfer the number from Final Inventory (Inventory - Used + Arrived ) to the next raw in Inventory using INDEX; however, I dont know how to insert the initial inventory number .in the inventory column. In excel this is pretty easy; the initial inventory goes in the first cell in the inventory column and the formula starts in the second row. I would appreciate the help to do this on Power BI using Power Query / DAX or M... Date // Inventory // Product Qty used // Product arrived // Final Inventory

As always, you are the best one

No caption?

i am having same data set and year from 2011 to 2014 but this is not working for me. i am adding subcategory and when i add this measure in table it shows nothing please help

Could you help me for quarterly.

I think this will miss an edge case where multiple skills are most known