Awesome video presentation. Excellent working examples. Thank you...,
@pivotalstats7 сағат бұрын
You are Welcome, thanks for watching!
@stanleyrhodesp12 сағат бұрын
Great Thankyou
@pivotalstats12 сағат бұрын
You are welcome!
@nourhanal-esawy231013 сағат бұрын
The Archive_date columns are in text data type and when I convert them into date type it gives me all the column error!! And I can’t find out how to fix it ! Can you help me please
@pivotalstats13 сағат бұрын
Hi, you can watch below video where I explain this issue and how to solve it. Hope this helps! kzbin.info/www/bejne/p6aof2qlp6yoiaM
@AmitKumar-ix3kqКүн бұрын
Please Correct me if I am wrong, but shouldn't the Function at 7:05 be RevDiscounted = SUMX(PizzaSales, ((PizzaSales[Sales] * PizzaSales[Price_USD])*.85)). Since the store ran a 15% discount so the pirce should be 85% of its initial price. Sorry I have not gone through the entire video at this point, but this doubt came to mind as soon as I saw this.
@pivotalstatsКүн бұрын
Hi, You are absolutely correct. I made a mistake there, it should have been .85 instead of .15. Thanks for highlighting, cheers!
@raghusiva93413 күн бұрын
Super bro keep going ur classes helps me a lot to learn new technologies best tutorials till now
@pivotalstats2 күн бұрын
Glad to hear that. Thanks for watching! :)
@shubhamgupta93233 күн бұрын
please bring course on microsoft fabrics
@pivotalstatsКүн бұрын
Sure will definitely try.
@shubhamgupta93234 күн бұрын
i tried using rankx in a measure but for me all the values in rank are coming came when i used in a table visual once i apply all function then it removes the filter at any column level in particular table. please tell. How for you values are showing different in measure does it handles differently in column level and measure level
@pivotalstatsКүн бұрын
RANKX in a measure can give you different results because it is calculated based on filter / row context applied to each visual, however in Calculated Column each row's rank is calculated independently. Check out below 2 videos which will give you a better understanding of how to structure your DAX: DAX Masterclass - kzbin.info/www/bejne/aqOmaoKtbJuhZrcsi=ikQ7f8jsRUn2XzMQ 2 Pillars of DAX Structuring: kzbin.info/www/bejne/a6PcpoStYtRlp5Ysi=rXvmdYs_fgEwSU4W
@ibrahim826494 күн бұрын
Your Explaination of the context are very clear and understandable. Thanks
@pivotalstats4 күн бұрын
Glad to hear that... Thanks for watching!
@tidyverse-lg5yo4 күн бұрын
Top! Thank youuu
@pivotalstats4 күн бұрын
You're welcome!
@nikhitabiradar21465 күн бұрын
Hi, can you tell me your thought process when you created the mapping table for "Specialty" field? what made you think of such filter and how you did it. Thank you for creating the video!
@pivotalstats4 күн бұрын
Hi, The only reason for creating a mapping table was to avoid information overload. Showing 50+ specialty in any type of graph will create a cluttered visual which is a bad design choice, especially when we already have a detailed grid view on the next page. Also to answer your question on how I did it. Since I have some previous experience in Healthcare domain, it was just a matter of a google search. Hope this help! Thanks for watching!
@Sanj201015 күн бұрын
Really great video, it covered everything and was easy to understand.. Thanks for this😊
HOW TO DOWNLOAD DATA OF PATIENT WAIT LIST IN THE LINK
@pivotalstats5 күн бұрын
Hi, when you scroll down, the first link you see on the page is for the data only. Just click the link to automatically download it.
@user-sk3gd9xx7x5 күн бұрын
very helpful...thank you..
@pivotalstats5 күн бұрын
You're welcome!
@tohema1006 күн бұрын
Very organized and helpful
@pivotalstats5 күн бұрын
Glad you liked it. Thanks for watching!
@mostafahwafy6 күн бұрын
plz.. can you make a list of this videos because it is not included in powerbi list and this is very good ideas plz create a playlist for it 😍
@pivotalstats6 күн бұрын
Sure thing 👍
@FilippoAlfareLovo6 күн бұрын
Thank you! I was struggling with nested SUMX, CALCULATE, FILTER... when all I was missing was the ALLEXCEPT!! illuminating :)
@pivotalstats6 күн бұрын
Excellent, Glad it helped !
@raviranjansingh55277 күн бұрын
thanks
@pivotalstats7 күн бұрын
Welcome!
@statesman63799 күн бұрын
I asked ChatGPT, “Is there a mode that does not support query folding?” Response: Yes, there is a mode in Power BI where query folding is not applicable: Import Mode. In Import Mode, data is loaded from the data source into the Power BI model, and all transformations are applied within the Power Query Editor before the data is loaded. Since the data is already loaded into the Power BI model, there is no need for query folding because there are no queries being sent back to the data source during report interactions. However, when discussing Dual Storage (composite models), it's important to note that the model can contain both imported data and DirectQuery-connected tables. For the imported data (i.e., tables loaded in Import Mode), query folding occurs during the data loading process within the Power Query Editor before the data is loaded into the model. For DirectQuery-connected tables, Power BI attempts to fold supported transformations back to the data source, leveraging the query engine of the data source.
@pivotalstats7 күн бұрын
👍
@MoeBig509 күн бұрын
Wonderful video I have been working with BI for over a year now and I learned alot from your videos.
@pivotalstats8 күн бұрын
Great to hear! Thanks for watching :)
@sambitpati612912 күн бұрын
If possible kindly make dashboard in incremental refresh load, forecasting, getting data from api like rapidapi and email notification
@pivotalstats11 күн бұрын
Noted, I will plan something!
@sambitpati612912 күн бұрын
thanks for this video, also need for pyspark data cleaning
@pivotalstats11 күн бұрын
Thanks for an excellent suggestion. I will keep this in mind when I cover big data related concepts. Cheers!
@sambitpati612912 күн бұрын
Well Done !!! nice tutorial and thanks for providing the dataset you have used, we can able to follow properly.
@pivotalstats11 күн бұрын
Glad it was helpful!
@chryzanoariston267012 күн бұрын
Wow, Im really impressed with all the intricate details you provided. Good job bro
@pivotalstats12 күн бұрын
Glad you enjoyed it. Thanks for watching!
@motomusicain2213 күн бұрын
Very good content why this is under rated i don't know!
@pivotalstats13 күн бұрын
Really glad it was helpful !
@kalkidanMesfen13 күн бұрын
Amazing, Just Amazing
@pivotalstats13 күн бұрын
Thank you so much :)
@ArunEnvisions13 күн бұрын
I'm a lead data analyst and Just saw this video... It's amazing... Congratulations... And subscribed 😍
@pivotalstats13 күн бұрын
Thanks for the sub! :)
@divyadsouze970114 күн бұрын
Very useful content.. Thank you Pivotalstas!! would you please upload some videos in relation to PL-300
@pivotalstats13 күн бұрын
Thanks! Sure I will upload soon.
@eugenebusigazi890014 күн бұрын
Hello tried to apply a pro tip on my data but it didn't work. Pls help Sir?
@pivotalstats14 күн бұрын
Can u explain the exact issue?
@eugenebusigazi890014 күн бұрын
@@pivotalstats when using the pro tip, on pressing the icon no pop up came for i can as the question?
@pivotalstats12 күн бұрын
@@eugenebusigazi8900 Could you paste your file in the below link? I will look into it when i get some time. Thanks! drive.google.com/drive/folders/1khpazVBjdSSbFrXMEJYzn7kiz3aKc2nR?usp=sharing
@jeissondavidsuesca15 күн бұрын
hi from bogota
@pivotalstats14 күн бұрын
Hello, thanks for watching! :)
@FabioMirandaSalles-do5kv16 күн бұрын
Thanks, safe_offset solved my query.
@pivotalstats16 күн бұрын
Glad it helped!
@SurajVarma-le4ud16 күн бұрын
COPY PASTE BELOW DAX code for the new custom column if you are also facing DATE PROBLEMS while using this provided date set try Date.FromText(Text.Start([Archive_Date], 2) & "-" & Text.Middle([Archive_Date], 3, 2) & "-" & Text.End([Archive_Date], 4)) otherwise try Date.FromText(Text.Middle([Archive_Date], 3, 2) & "-" & Text.Start([Archive_Date], 2) & "-" & Text.End([Archive_Date], 4)) otherwise try Date.FromText(Text.Middle([Archive_Date], 4, 2) & "-" & Text.Start([Archive_Date], 2) & "-" & Text.End([Archive_Date], 2)) otherwise Date.FromText([Archive_Date]) then change the date type in the new created column.
@pivotalstats16 күн бұрын
Thanks for the assist buddy ! In case anyone wants to checkout, I have a video on my channel explaining the date conversion error in detail (link below) kzbin.info/www/bejne/p6aof2qlp6yoiaM
@CAKPRashique17 күн бұрын
Let me let u know, u r great teacher. Thanks for knowledge
@pivotalstats16 күн бұрын
Thank you! 😃
@hemantkumarchaurasia72217 күн бұрын
This is the best dax tutorial ever seen on youtube. Hope that more useful content will be shared by the Pivotalstats🙏
@pivotalstats17 күн бұрын
Much appreciated! Will definitely try my best :)
@nariroeplal155318 күн бұрын
Best and easiest explained. Please do upload more😅
@pivotalstats17 күн бұрын
Thank you, I will !
@user-qh5fr3yo1w18 күн бұрын
Автору большое спасибо. Всё разбирается по шагам.
@pivotalstats18 күн бұрын
Glad you liked it 🙂
@thenoorchannel207419 күн бұрын
Anyone want to connect to do this tutorial, I m getting stuck in several places
@pivotalstats19 күн бұрын
Hi, you can download the final pbix from below link to tally with your file www.pivotalstats.com/resources
@brayanremicio597620 күн бұрын
Hi! I'd appreciate your help validating this: How can I create a filter for a range of numbers in the clause WHERE? I want to filter numeric data between 1 and 3. I know we can use that clause "BETWEEN _ AND"; however, this works to bring up the range, but it doesn't filter the range to avoid that info.
@pivotalstats20 күн бұрын
Hi, If I understood your question correctly, you want to filter the data excluding numeric data between 1 and 3. If this is the case then you can use following in your where clause : "NOT BETWEEN 1 AND 3"
@inderpanda121 күн бұрын
Wow what an amazing Explanation 👏🏻👏🏻👏🏻 Do upload video atleast ever week
@pivotalstats20 күн бұрын
Thank you, I will try my best 👍
@user-qc1ct8jb7u21 күн бұрын
Really good ...
@pivotalstats20 күн бұрын
Thanks a lot 😊
@Kiranmai3022 күн бұрын
Crystal clear, tq very much
@pivotalstats22 күн бұрын
You are welcome!
@EBUCOOLGUY22 күн бұрын
This is priceless. Thanks for sharing and bringing more clarity to Power BI
@pivotalstats22 күн бұрын
Glad it was helpful!
@arjunghosh865422 күн бұрын
Very good explained.could be slower
@pivotalstats22 күн бұрын
Thanks for the feedback. Noted for next time!
@oukiebotha222722 күн бұрын
The best DAX tutorial. Many thanks. Much appreciated....Thank you..Thank you..🙏🙏🏆🏆👌👌
@pivotalstats22 күн бұрын
You're very welcome! Thanks for watching!!
@sunlight0000023 күн бұрын
Hi! a newbie here in PowerBI.Is this much DAX is enough to get into industry?
@pivotalstats23 күн бұрын
Hi, yes this is a good starting point for you. Once you understand how to structure the dax using this video, you can then move on to creating more complex logics by combining what you learned.
@michelcockerham210925 күн бұрын
20:41 there are two 'Specialty_ Name' how did you make your determination? pls help!
@pivotalstats24 күн бұрын
I chose the Specialty in the mapping table for my filters because filter context is flowing from that table to the main table. You can see that by observing the arrow on the connection line. This also make sure that my filter does not have any duplicate values, since all values in my mapping table is unique. Hope this helped!
@vishnuvarthan56425 күн бұрын
Great thanks for this. Alternative can we use WITH ?
@pivotalstats25 күн бұрын
Thanks for watching! No you cannot use WITH instead of HAVING. I have not covered that in this video but WITH is used to create CTE. I will plan something for future. Hope this helps!
@vishnuvarthan56425 күн бұрын
@@pivotalstats definitely. Thanks a million for your quick response 👍
@sha246025 күн бұрын
Please upload more gcp data engineering videos. And thanks for this tutorial
@pivotalstats25 күн бұрын
Sure, thanks for watching!
@hemanthboyapati337226 күн бұрын
I Finally understood query folding in detail. Thank you!