Hi,I have recently started learning powerBI.But always had a confusion as where and how to start preparing dashboards to add in my portfolio. ur video was so interesting and loaded with lot of info.I prepared my first dasboard.Thank you.
Thank you so much! You've helped me a lot in learning SQL and Power BI these past few months. I hope you can make another scenarioes using both SQL and Power BI. Thank you
FYI, If anyone having issue with Scenario 2, when dropping Max Point measure in the Line Chart, All the markers are getting highlighted. Use the below mentioned measure Max Point 1 = IF(MAXX(ALLSELECTED('Calendar Table'[Month],'Calendar Table'[Month Number]),[Total Sales]) = [Total Sales], MAXX(ALLSELECTED('Calendar Table'[Month],'Calendar Table'[Month Number]),[Total Sales]),BLANK()) in ALLSELECTED(), i'm giving month number as well.
Grt- way of handing session but pls take few more sessions for real time use cases like through parameter selection for Rolling N Months , Top N , compare This this year sales wrt previous year sales etc..............
Thank you so much for this insightful video! Your explanations were clear, and I loved the practical examples you shared. It really helped me reduce my learning curve . Keep up the excellent work. Can’t wait to see more of your informative videos in the future. 😊
Thanks for nice videos, Really it is helpful while attending interview , i got an few same questions my last interivew , luckly I watched your videos, (Rolling fashion one year sales Question), Just want to know , for the last six month sales questions, we are able to achieve it LASTDATE instead of Max as well right?.
I noticed your months in scenario two are out of order chronologically. They are sorted alphabetically. You need to add a month number column on the calendar table and sort the month column by the month number column.
When you deal with time based calculations it is always recommended to use calendar or date table. It helps you to change the fiscal years, missing dates, time intelligence functions, etc
Why is the following measure fetching incorrect results for the last six month sales? last six sales = CALCULATE([temp_sales],AND('Calendar'[Date] MAX('Calendar'[Date])-180)). Here temp sales is a measure indicating the total Sales
Hi, I am facing an error while createing line graph in the 2nd question. The error says "Can't convert value "jan" of text to type date while processing column - calender[month]-> sales data[order date] what can I do ?
there are 5 columns in a student table and more than 100 students are in the database for different subject marks like physics, chemistry, maths, English and Hindi. If a student login in a dashboard then he would only see his marks not other students marks. How will you achieve this using dax(not to use dynamic rls )
![Power BI DAX Tutorial - Beginner to Advanced [Full Course]](http://i.ytimg.com/vi/4rC9Ow76n0U/mqdefault.jpg)
Great teaching highly appreciated.
Hi,I have recently started learning powerBI.But always had a confusion as where and how to start preparing dashboards to add in my portfolio.
ur video was so interesting and loaded with lot of info.I prepared my first dasboard.Thank you.
Thank you so much! You've helped me a lot in learning SQL and Power BI these past few months. I hope you can make another scenarioes using both SQL and Power BI. Thank you
Thanks, will do!
Hey @shielamuzdaliffa is SQL, pow bi enuff to get a job in power bi ?
FYI, If anyone having issue with Scenario 2, when dropping Max Point measure in the Line Chart, All the markers are getting highlighted. Use the below mentioned measure
Max Point 1 = IF(MAXX(ALLSELECTED('Calendar Table'[Month],'Calendar Table'[Month Number]),[Total Sales]) = [Total Sales], MAXX(ALLSELECTED('Calendar Table'[Month],'Calendar Table'[Month Number]),[Total Sales]),BLANK())
in ALLSELECTED(), i'm giving month number as well.
Thank you for this .But why month number is needed?
Very useful, thanks for great video. Made same for power bi service scenario based is much appreciated. Thanks
Very nice video 🎉 thank you
Welcome 😊
please do some videos on etl too.
Definitely
Thank you so much, please make more similar videos.
Grt- way of handing session but pls take few more sessions for real time use cases like through parameter selection for Rolling N Months , Top N , compare This this year sales wrt previous year sales etc..............
Sure
Thanks... this is helpful...is there a way to make first scenario more dynamic using parameters
Thanks alot bro those tricks are really useful 🙏
Thank you so much for this insightful video! Your explanations were clear, and I loved the practical examples you shared. It really helped me reduce my learning curve . Keep up the excellent work. Can’t wait to see more of your informative videos in the future. 😊
Glad it was helpful!
Thanks for nice videos, Really it is helpful while attending interview , i got an few same questions my last interivew , luckly I watched your videos, (Rolling fashion one year sales Question), Just want to know , for the last six month sales questions, we are able to achieve it LASTDATE instead of Max as well right?.
I noticed your months in scenario two are out of order chronologically. They are sorted alphabetically. You need to add a month number column on the calendar table and sort the month column by the month number column.
finished watching
Great work
Great video,
Linked and subscribed 👍
thank you soooo much sir
Nice video bro clearly explained...so helpfulll
Glad you liked it
Thanks sir
amazing video
Glad you think so!
Thank you sir 😄
Why not simply use the hierarchial Order Date? instead of creating a new table for Calendar. is there any difference? Thank you for your answer.
When you deal with time based calculations it is always recommended to use calendar or date table. It helps you to change the fiscal years, missing dates, time intelligence functions, etc
Thanks so much!@@datatutorials1
Why is the following measure fetching incorrect results for the last six month sales? last six sales = CALCULATE([temp_sales],AND('Calendar'[Date] MAX('Calendar'[Date])-180)). Here temp sales is a measure indicating the total Sales
For Sale in last 6 month it s calculating for entire Dec month not till last date. Is there any correction?
Instead of DATESINPERIOD, Why can't i use DATEADD
Last 6 months Sales = CALCULATE([Total Sales],DATEADD('Calendar'[Date],-6,MONTH))
Hi, I am facing an error while createing line graph in the 2nd question. The error says "Can't convert value "jan" of text to type date while processing column - calender[month]-> sales data[order date]
what can I do ?
there are 5 columns in a student table and more than 100 students are in the database for different subject marks like physics, chemistry, maths, English and Hindi. If a student login in a dashboard then he would only see his marks not other students marks. How will you achieve this using dax(not to use dynamic rls )
Don't know TOPN function is not working in my laptop , could you please suggest what should i do?
without creating measure you can use filter top n in card visual
Hi
I am not getting the Max & Min highlight in line chart...y please help me / same method is applied
am also not egtting same i followed
How maxx of months sales = total sales. It is showing false
Excellent Video Thanks a lot for your hard works such video really helps us !!!! I have subscribe to your channel!!!