วีดีโอ

Great Tutorial! Well done.

can i get the dataset please?

Can't First day of sale be done by min(Date of sale) rather than creating a new column?

Very good explanation. Thanks 👍

Thank you for the video. What if the Visual is Guage instead of Bar chart?

what if we have some duplicate entries in total spend column it skip the rank

hello sir can you please share sample data so we can practice parallel

Best content on PowerBI

Great tutorial, thanks! Works like a charm 🥳

Found this when I needed it . Thank you

Could you please provide data set, it will be helpful to us to practice. 1 million times thanks.

You are the Super. Everywhere we can find the Dax function and it's use but here only we can get Scenario based explanation in detail. Awesome explanation with patience. Thanks a lot.

Helpful

Provide data sets

Plz provide datasets otherwise it will be useless

I did all the things you did...but somehow its not hiding...I don't know where did it go wrong

Nice explanation.

this is what i was searching for, thank you, also is there a way to send alert to multiple users

Explanation is very nice. Thank You

Can you provide your contact details sir

It’s better please share the data for practice as I saw the maximum TH-camr are doing the same practice

Thank you, Been on it for 2 days

can we set a background color for the whole row if one column is having 1 or 0. Example if one of value in that column is 1 then green on whole row else if 0 then red on whole row.

hi sir,along with month, we need WEEK NOs also...How to get WEEK Wise data ...2nd query is , Our weeks are fixed in each month i.e. Dat 1 to7 is 1st wk, 8 to 15 -2nd ,16-23 is 3rd wk, 23 to end of month is 4th wk...Hence we have 48 wks per year...So we want WEEK NOs this way... Is this possible to achieve above 2 queries solution in powerbi?

Thank you for the content, but do you know if it is possible to have just a subset of pre-selected columns when user runs the report?

Nice!

Where is voice?

Useful one brother Thanku so much

Thanks for sharing real time example. Great Job !!

Thank you brother for explaining the whole concept. doing really great job. one suggestion could you pls check your audio quality. I have noticed the quality of audio is not clear need to fix it, thanks once again for the expalanation

nice one bhai

Hi your videos are amazing but i have one urgent requirement please can you help me at the earliest by making video how to create normal bar and clustered stacked bar chart in excel for 2 years, as normal bar will be totL sales for 2023 and clustered stacked bar should have both sales values and %on sales month wise for 12 months, it would b a great help... Thanks in advance

Another feasible Option would the following one : Most Active Day = MAXX( TOPN (1, SUMMARIZE ( DimDates, DimDates [WeekDayName], "Transactions", [Transactions] ) , [Tran] , DESC ) , DimDates[WeekDayName] )

thanks for video sir watching in 2024 helping a lot to solve issue

Nice one Mishra Bhai 😊. Thanku so much

Dataset:- docs.google.com/spreadsheets/d/1D_I3mvh2ftvj2_oMHFbruGXPisoaeyCT/edit#gid=1511363485 DAX Code:- Net Revenue = Var vDepId= Max(Dept[DeptId]) Var VDepDetail=Max(Dept[Detail]) Var vTeamDetail= Max(Emp[TeamDetail]) Var vTeamScope=ISINSCOPE(Emp[TeamName]) Var vSubTeamScope=ISINSCOPE(Emp[SubTeam]) Var Rsum= CALCULATE( [Total Revenue], FILTER( ALL(Dept), Dept[DeptId]<=vDepId ) ) Var VResult= SWITCH( TRUE(), vTeamDetail=0 && vSubTeamScope=TRUE(), Blank(), VDepDetail=0 && vTeamScope=FALSE(),Rsum, VDepDetail=1,[Total Revenue], BLANK() ) RETURN VResult

nice one mishra bhai thanku so much

Dataset Link:- docs.google.com/spreadsheets/d/1D_I3mvh2ftvj2_oMHFbruGXPisoaeyCT/edit#gid=1167653766

👌👌👌

interested

Power BI Course Details: - Module 1- 1. Introduction to Power BI 2. Installation 3. Data Cleansing & Transformation using Power Query 4. Define Star Model 5. Create Date Table using M Language 6. Create Basic Measures 7. Difference Between Row Context & Filter Context 8. Sales Dashboard Creation: - a. Define Templates b. Colour Schemes c. Tool Tips d. Hierarchy e. Page Navigation f. Bookmark g. Sync Filters h. Formatting etc…. any More 9. DAX Task with Realtime Problems needs to solved after completion of Module 3 a. Ratio & Proption Analysis b. Segment Analysis c. Dynamic Relationships d. Top Selling Product with e. Budget Analysis f. Set Operation g. How to Handle Bi-Directional Filter Others complex scenario as well. Module 2- 1. Deep Understanding of M language to do data cleansing using Power Query 2. Revenue Analysis 3. Create Education System Dashboard. Module 3- 1. Introduction to DAX 2. DAX Calculation 3. DAX Operators/Comments 4. Variables 5. Calculate Tables: - a. Values Function b. Distinct c. Union d. Create Calendar Table e. Add Columns f. Filter g. Summarize 6. Calculated Columns: - a. IF/SWITCH b. Row Context c. Related d. Related Table 7. Aggregate Functions: - a. SUM/Avg/Count Function b. Countrows 8. Context:- a. Evaluation Context b. How Filter Context Works c. Filter Context & Cross Filter Direction 9. Iterators:- a. SumX b. AverageX c. MinX d. MaxX 10. Calculate:- a. Calclate Function with Different Variation b. Remove Filters c. ALL d. Allselected e. AlLExcept f. ISINSCOPE g. CalculateTable Function 11. Ranking Function:- a. Rankx b. TopN 12. Time Intelligence Function in Details 13. Relationships:- a. Treat AS b. UseRelationship 14. HR Case Study and Dashboard Module 4:- Financial Analysis 1. Understand Financial Data 2. Prepare Income Statement Dashboard Using Power BI 3. Perform Vertical & Horizontal Analysis Module 5:- Power BI Services:- 1. Row Level Security(Static/Dynamic) 2. Power BI Gateway 3. Dataflows 4. DataMarts 5. Workspace 6. App Creation 7. Deployment Pipeline 8. Scheduling Data Refresh 9. Dashboard 10. Alerts 11. Subscriptions 12. How to Work on Import/Direct Query & Live Mode.

Thanks for uploading this video.

Is the table dynamic eg if you added a new category D to your source file and refreshed the power query will the index auto populate to 104 recognising the new category?

How to achieve the same thing if it is a table visual because table header is still showing

I am surprised this video is not like more. This is incredibly useful! Thank you so much! 💪

Can we use today() function instead of max(date) ,so we can calculate according to today's date....

Very informative but your voice is very low

Good content,please keep posted useful stuff like this,thank you

Awesome tutorial on the powerful calulate()! Concise and crystal clear. 1. Overriding the filter context over a column . 2. Removing the filters over one column or the entire table. 3. Filtering over diferent tables. Must nestle the filter() in calculate and use the navegação related(). 4. Keep it simpler, use the shorthand syntax: calculate(expression, criteria). Thank you for sharing, Sir! I can't wait for the next sesion on the series! I am a self learner and relatively new to this amazing visualization tool, powerbi, and I am really making tremendous progress thanks to the valuable and quality tutorials arround just like this one, from committed and dedicated folks like you!

Really fantastic explanation bhai 🙏🙏🙏