Пікірлер
@anillpatel
@anillpatel 9 сағат бұрын
Awesome video presentation. Excellent working examples. Thank you...,
@pivotalstats
@pivotalstats 7 сағат бұрын
You are Welcome, thanks for watching!
@stanleyrhodesp
@stanleyrhodesp 12 сағат бұрын
Great Thankyou
@pivotalstats
@pivotalstats 12 сағат бұрын
You are welcome!
@nourhanal-esawy2310
@nourhanal-esawy2310 13 сағат бұрын
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
@pivotalstats
@pivotalstats 13 сағат бұрын
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
@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
@pivotalstats Күн бұрын
Hi, You are absolutely correct. I made a mistake there, it should have been .85 instead of .15. Thanks for highlighting, cheers!
@raghusiva9341
@raghusiva9341 3 күн бұрын
Super bro keep going ur classes helps me a lot to learn new technologies best tutorials till now
@pivotalstats
@pivotalstats 2 күн бұрын
Glad to hear that. Thanks for watching! :)
@shubhamgupta9323
@shubhamgupta9323 3 күн бұрын
please bring course on microsoft fabrics
@pivotalstats
@pivotalstats Күн бұрын
Sure will definitely try.
@shubhamgupta9323
@shubhamgupta9323 4 күн бұрын
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
@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
@ibrahim82649
@ibrahim82649 4 күн бұрын
Your Explaination of the context are very clear and understandable. Thanks
@pivotalstats
@pivotalstats 4 күн бұрын
Glad to hear that... Thanks for watching!
@tidyverse-lg5yo
@tidyverse-lg5yo 4 күн бұрын
Top! Thank youuu
@pivotalstats
@pivotalstats 4 күн бұрын
You're welcome!
@nikhitabiradar2146
@nikhitabiradar2146 5 күн бұрын
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!
@pivotalstats
@pivotalstats 4 күн бұрын
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!
@Sanj20101
@Sanj20101 5 күн бұрын
Really great video, it covered everything and was easy to understand.. Thanks for this😊
@pivotalstats
@pivotalstats 5 күн бұрын
You're very welcome!
@Cricstory0108
@Cricstory0108 5 күн бұрын
Sir column merge nahi ho rahe ha
@pivotalstats
@pivotalstats 4 күн бұрын
Kuch error aa raha hai kya?
@vishwassingh2762
@vishwassingh2762 5 күн бұрын
Creation Storage Usage Archiving Retention Deletion
@pivotalstats
@pivotalstats 5 күн бұрын
👍
@jaijaiswal1290
@jaijaiswal1290 5 күн бұрын
HOW TO DOWNLOAD DATA OF PATIENT WAIT LIST IN THE LINK
@pivotalstats
@pivotalstats 5 күн бұрын
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-sk3gd9xx7x
@user-sk3gd9xx7x 5 күн бұрын
very helpful...thank you..
@pivotalstats
@pivotalstats 5 күн бұрын
You're welcome!
@tohema100
@tohema100 6 күн бұрын
Very organized and helpful
@pivotalstats
@pivotalstats 5 күн бұрын
Glad you liked it. Thanks for watching!
@mostafahwafy
@mostafahwafy 6 күн бұрын
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 😍
@pivotalstats
@pivotalstats 6 күн бұрын
Sure thing 👍
@FilippoAlfareLovo
@FilippoAlfareLovo 6 күн бұрын
Thank you! I was struggling with nested SUMX, CALCULATE, FILTER... when all I was missing was the ALLEXCEPT!! illuminating :)
@pivotalstats
@pivotalstats 6 күн бұрын
Excellent, Glad it helped !
@raviranjansingh5527
@raviranjansingh5527 7 күн бұрын
thanks
@pivotalstats
@pivotalstats 7 күн бұрын
Welcome!
@statesman6379
@statesman6379 9 күн бұрын
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.
@pivotalstats
@pivotalstats 7 күн бұрын
👍
@MoeBig50
@MoeBig50 9 күн бұрын
Wonderful video I have been working with BI for over a year now and I learned alot from your videos.
@pivotalstats
@pivotalstats 8 күн бұрын
Great to hear! Thanks for watching :)
@sambitpati6129
@sambitpati6129 12 күн бұрын
If possible kindly make dashboard in incremental refresh load, forecasting, getting data from api like rapidapi and email notification
@pivotalstats
@pivotalstats 11 күн бұрын
Noted, I will plan something!
@sambitpati6129
@sambitpati6129 12 күн бұрын
thanks for this video, also need for pyspark data cleaning
@pivotalstats
@pivotalstats 11 күн бұрын
Thanks for an excellent suggestion. I will keep this in mind when I cover big data related concepts. Cheers!
@sambitpati6129
@sambitpati6129 12 күн бұрын
Well Done !!! nice tutorial and thanks for providing the dataset you have used, we can able to follow properly.
@pivotalstats
@pivotalstats 11 күн бұрын
Glad it was helpful!
@chryzanoariston2670
@chryzanoariston2670 12 күн бұрын
Wow, Im really impressed with all the intricate details you provided. Good job bro
@pivotalstats
@pivotalstats 12 күн бұрын
Glad you enjoyed it. Thanks for watching!
@motomusicain22
@motomusicain22 13 күн бұрын
Very good content why this is under rated i don't know!
@pivotalstats
@pivotalstats 13 күн бұрын
Really glad it was helpful !
@kalkidanMesfen
@kalkidanMesfen 13 күн бұрын
Amazing, Just Amazing
@pivotalstats
@pivotalstats 13 күн бұрын
Thank you so much :)
@ArunEnvisions
@ArunEnvisions 13 күн бұрын
I'm a lead data analyst and Just saw this video... It's amazing... Congratulations... And subscribed 😍
@pivotalstats
@pivotalstats 13 күн бұрын
Thanks for the sub! :)
@divyadsouze9701
@divyadsouze9701 14 күн бұрын
Very useful content.. Thank you Pivotalstas!! would you please upload some videos in relation to PL-300
@pivotalstats
@pivotalstats 13 күн бұрын
Thanks! Sure I will upload soon.
@eugenebusigazi8900
@eugenebusigazi8900 14 күн бұрын
Hello tried to apply a pro tip on my data but it didn't work. Pls help Sir?
@pivotalstats
@pivotalstats 14 күн бұрын
Can u explain the exact issue?
@eugenebusigazi8900
@eugenebusigazi8900 14 күн бұрын
@@pivotalstats when using the pro tip, on pressing the icon no pop up came for i can as the question?
@pivotalstats
@pivotalstats 12 күн бұрын
@@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
@jeissondavidsuesca
@jeissondavidsuesca 15 күн бұрын
hi from bogota
@pivotalstats
@pivotalstats 14 күн бұрын
Hello, thanks for watching! :)
@FabioMirandaSalles-do5kv
@FabioMirandaSalles-do5kv 16 күн бұрын
Thanks, safe_offset solved my query.
@pivotalstats
@pivotalstats 16 күн бұрын
Glad it helped!
@SurajVarma-le4ud
@SurajVarma-le4ud 16 күн бұрын
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.
@pivotalstats
@pivotalstats 16 күн бұрын
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
@CAKPRashique
@CAKPRashique 17 күн бұрын
Let me let u know, u r great teacher. Thanks for knowledge
@pivotalstats
@pivotalstats 16 күн бұрын
Thank you! 😃
@hemantkumarchaurasia722
@hemantkumarchaurasia722 17 күн бұрын
This is the best dax tutorial ever seen on youtube. Hope that more useful content will be shared by the Pivotalstats🙏
@pivotalstats
@pivotalstats 17 күн бұрын
Much appreciated! Will definitely try my best :)
@nariroeplal1553
@nariroeplal1553 18 күн бұрын
Best and easiest explained. Please do upload more😅
@pivotalstats
@pivotalstats 17 күн бұрын
Thank you, I will !
@user-qh5fr3yo1w
@user-qh5fr3yo1w 18 күн бұрын
Автору большое спасибо. Всё разбирается по шагам.
@pivotalstats
@pivotalstats 18 күн бұрын
Glad you liked it 🙂
@thenoorchannel2074
@thenoorchannel2074 19 күн бұрын
Anyone want to connect to do this tutorial, I m getting stuck in several places
@pivotalstats
@pivotalstats 19 күн бұрын
Hi, you can download the final pbix from below link to tally with your file www.pivotalstats.com/resources
@brayanremicio5976
@brayanremicio5976 20 күн бұрын
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.
@pivotalstats
@pivotalstats 20 күн бұрын
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"
@inderpanda1
@inderpanda1 21 күн бұрын
Wow what an amazing Explanation 👏🏻👏🏻👏🏻 Do upload video atleast ever week
@pivotalstats
@pivotalstats 20 күн бұрын
Thank you, I will try my best 👍
@user-qc1ct8jb7u
@user-qc1ct8jb7u 21 күн бұрын
Really good ...
@pivotalstats
@pivotalstats 20 күн бұрын
Thanks a lot 😊
@Kiranmai30
@Kiranmai30 22 күн бұрын
Crystal clear, tq very much
@pivotalstats
@pivotalstats 22 күн бұрын
You are welcome!
@EBUCOOLGUY
@EBUCOOLGUY 22 күн бұрын
This is priceless. Thanks for sharing and bringing more clarity to Power BI
@pivotalstats
@pivotalstats 22 күн бұрын
Glad it was helpful!
@arjunghosh8654
@arjunghosh8654 22 күн бұрын
Very good explained.could be slower
@pivotalstats
@pivotalstats 22 күн бұрын
Thanks for the feedback. Noted for next time!
@oukiebotha2227
@oukiebotha2227 22 күн бұрын
The best DAX tutorial. Many thanks. Much appreciated....Thank you..Thank you..🙏🙏🏆🏆👌👌
@pivotalstats
@pivotalstats 22 күн бұрын
You're very welcome! Thanks for watching!!
@sunlight00000
@sunlight00000 23 күн бұрын
Hi! a newbie here in PowerBI.Is this much DAX is enough to get into industry?
@pivotalstats
@pivotalstats 23 күн бұрын
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.
@michelcockerham2109
@michelcockerham2109 25 күн бұрын
20:41 there are two 'Specialty_ Name' how did you make your determination? pls help!
@pivotalstats
@pivotalstats 24 күн бұрын
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!
@vishnuvarthan564
@vishnuvarthan564 25 күн бұрын
Great thanks for this. Alternative can we use WITH ?
@pivotalstats
@pivotalstats 25 күн бұрын
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!
@vishnuvarthan564
@vishnuvarthan564 25 күн бұрын
@@pivotalstats definitely. Thanks a million for your quick response 👍
@sha2460
@sha2460 25 күн бұрын
Please upload more gcp data engineering videos. And thanks for this tutorial
@pivotalstats
@pivotalstats 25 күн бұрын
Sure, thanks for watching!
@hemanthboyapati3372
@hemanthboyapati3372 26 күн бұрын
I Finally understood query folding in detail. Thank you!
@pivotalstats
@pivotalstats 26 күн бұрын
You are welcome!