Great video. Helping me 5 years later

Hi, I also noticed the below two formulas yield slightly different results i.e. the first one gives totals at the Year and Month levels whilst the last formula does not. I thought both formulas mean the same..... Widgets Qty Last Stock Trade Date = CALCULATE( [Sum Widgets], ------> HERE WE REFER TO THE MEASURE LASTNONBLANK( StockLevel[Stock Taking Date].[Date], [Sum Widgets] -----> HERE WE REFER TO THE MEASURE ) ) vs. Widgets Qty Last Stock Trade Date = CALCULATE( SUM(StockLevel[Widgets]), ------> HERE WE REDEFINE THE MEASURE EXPLICITYLY LASTNONBLANK( StockLevel[Stock Taking Date].[Date], SUM(StockLevel[Widgets]) ------> HERE WE REDEFINE THE MEASURE EXPLICITYLY ) )

How do I use SWITCH(TRUE) to solve this based on the Movies data: Create a column using SWITCH(TRUE()) to classify studios as "Small" (produced < 5 films), "Medium" (5-15 films), "Large" (more than 15 films).

Hi, @ 08:31 minutes in the video, when you write the measure for [Close Price on Last Date of Interval] I was wondering why you did not use the already existing measure [Last Date of Interval] inside the formula?

how did you guys get the access for the sql script and the apps table?

Great tutorial. Thank you!

Very informative and great to solidify Power BI DAX Basics!

Hi. Why do we use the column name only instead of table name and column name in the functions calls that create the table columns? e.g. DAY([Date]), why isn't it DAY('ReleaseCalendar'[Date])?

Thanks! Found your channel through a Reddit post, learning VBA in my downtime at work to try. Should be a useful skill to have in corporate America. Thanks for making these tutorials!

Probably the best playlist on YT about DAX. I just love the way you teach by building the concept and why we are using the specific formula Thank you so much sir

I think your voice should be used in all tutorials on YT😅. Thank you for all the great content.

Great tutorial. One small doubt, when I am placing Oscar Success on Y-axis then it is showing count of Oscars as 6 for Genre Family but when we place Oscar Success in Legend section it is showing count of Oscars as 0. When I see the Movies data, there are no Oscars for Family Genre. In Movies data, there are 6 records for Genre Family, it is showing that count. Could you please help me in understanding this scenario.

Hi , can you please share the how to create = date year, 1 hour interval ?

Is it possible to use Stored Procedure in Fabric ? data source is a Lakehouse or a semantic model in Power Report BI Builder, options Tables and Stored Procedures are disable when the data source is a Lake or Semantic Model. Thanks.

When we go to next page, we lose header, even though RepeatOnNewPage is set to true, how to fix that?

thinks 😀

Sir make dax playlist free plz

Hello ! Why not start M Query Language playlist on your channel ?

Best of all!

how did you format the input for file identifier on the 'get files in this sharepoint folder' step? I'm having trouble getting that step to work :(

Hi Andy, I have some code that counts the number of cases that are over 'x' amount of days old that works. I have a second measure that tries to calculate the value of 'x' a month ago but it just gives me a - - result (its not a BLANK and its not empty). Would it be possible to send you the code for you to see if there are any glaring mistakes in it? If so, could I paste it here or is there another way to send you it? I have added comments to the code to help explain what's what. Thanks

does the SharePoint portion work with SharePoint Lists, or only with a folder of documents? if not, is there a way to change this process to work the same with a SharePoint List or maybe even to return the number of items in a List with a specific label or value in a certain field?

I was looking for how to work with this type of object and found this video. However, I saw that using SeleniumBasic it is not possible to execute the method.

Is SSRS still being worth learning, is in Use in current IT companies?

Thanks WiseOwl. Please make a series on power bi data model.

Magnificent as usual. Greetings from Egypt.

Hey, what if you want to reference multiple columns from different tables in the ALLEXCEPT function? How would you do that please? Thank you

Why when I use insert into with ado all data when is store save like '8

what if there was a title that did not have, country, budget dollars, box office, or profit dollars in the database? How would you get it to list on the left hand side anyway? For example if there is a not a "country.id" to join it with but you still wanted to list the movie under the title to show that it had unknown country/0 for everything to its right? How would you go about that?

Thanks!

That is such an epic video like the rest of your videos

Id Name Series Category Mentor Finished 1 Steve Brookstein 1 Over 25s Simon Cowell 1 2 Shayne Ward 2 16-24s Louis Walsh 1 3 Leona Lewis 3 16-24s Simon Cowell 1 4 Leon Jackson 4 Boys Dannii Minogue 1 5 Alexandra Burke 5 Girls Cheryl Cole 1 6 Joe McElderry 6 Boys Cheryl Cole 1 7 Matt Cardle 7 Boys Dannii Minogue 1 8 Little Mix (Rhythmix) 8 Groups Tulisa Contostavlos 1 9 James Arthur 9 Boys Nicole Scherzinger 1 10 G4 1 Groups Louis Walsh 2 11 Andy Abraham 2 Over 25s Sharon Osbourne 2 12 Ray Quinn 3 16-24s Simon Cowell 2 13 Rhydian 4 Boys Dannii Minogue 2 14 JLS 5 Groups Louis Walsh 2 15 Olly Murs 6 Boys Simon Cowell 2 16 Rebecca Ferguson 7 Girls Cheryl Cole 2 17 Marcus Collins 8 Boys Gary Barlow 2 18 Jahméne Douglas 9 Boys Nicole Scherzinger 2 19 Tabby Callaghan 1 16-24s Sharon Osbourne 3 20 Journey South 2 Groups Simon Cowell 3 21 Ben Mills 3 Over 25s Sharon Osbourne 3 22 Same Difference 4 Groups Simon Cowell 3 23 Eoghan Quigg 5 Boys Simon Cowell 3 24 Stacey Solomon 6 Girls Dannii Minogue 3 25 One Direction 7 Boys Simon Cowell 3 26 Amelia Lily 8 Girls Kelly Rowland 3 27 Christopher Maloney 9 Over 28s Gary Barlow 3 28 Rowetta Satchell 1 Over 25s Sharon Osbourne 4 29 Brenda Edwards 2 Over 25s Sharon Osbourne 4 30 The MacDonald Brothers 3 Groups Louis Walsh 4 31 Niki Evans 4 Over 25s Louis Walsh 4 32 Diana Vickers 5 Girls Cheryl Cole 4 33 Danyl Johnson 6 Over 25s Simon Cowell 4 34 Cher Lloyd 7 Girls Cheryl Cole 4 35 Misha B 8 Girls Kelly Rowland 4 36 Union J 9 Groups Louis Walsh 4 37 Cassie Compton 1 16-24s Sharon Osbourne 5 38 Chico Slimani 2 Over 25s Sharon Osbourne 5 39 Eton Road 3 Groups Simon Cowell 5 40 Hope 4 Groups Simon Cowell 5 41 Ruth Lorenzo 5 Over 25s Dannii Minogue 5 42 Lloyd Daniels 6 Boys Cheryl Cole 5 43 Mary Byrne 7 Over 28s Louis Walsh 5 44 Janet Devlin 8 Girls Kelly Rowland 5 45 Rylan Clark 9 Boys Nicole Scherzinger 5 46 Voices with Soul 1 Groups Louis Walsh 6 47 The Conway Sisters 2 Groups Louis Walsh 6 48 Robert Allen 3 Over 25s Sharon Osbourne 6 49 Beverley Trotman 4 Over 25s Louis Walsh 6 50 Rachel Hylton 5 Girls Dannii Minogue 6 51 John & Edward 6 Groups Louis Walsh 6 52 Wagner 7 Over 28s Louis Walsh 6 53 Craig Colton 8 Boys Gary Barlow 6 54 Ella Henderson 9 Girls Tulisa Contostavlos 6 55 2 to Go 1 Groups Louis Walsh 7 56 Nicholas Dorsett 2 16-24s Louis Walsh 7 57 Nikitta Angus 3 16-24s Simon Cowell 7 58 Alisha Bennett 4 Girls Sharon Osbourne 7 59 Daniel Evans 5 Over 25s Dannii Minogue 7 60 Jamie Archer 6 Over 25s Simon Cowell 7 61 Katie Waissel 7 Girls Cheryl Cole 7 62 Kitty Brucknell 8 Over 25s Louis Walsh 7 63 District3 9 Groups Louis Walsh 7 64 Verity Keays 1 Over 25s Simon Cowell 8 65 Maria Lawson 2 Over 25s Sharon Osbourne 8 66 Ashley McKenzie 3 16-24s Simon Cowell 8 67 Andy Williams 4 Boys Dannii Minogue 8 68 Laura White 5 Girls Cheryl Cole 8 69 Lucie Jones 6 Girls Dannii Minogue 8 70 Paije Richardson 7 Boys Dannii Minogue 8 71 Kye Sones 8 Over 28s Gary Barlow 8 72 Roberta Howett 1 16-24s Sharon Osbourne 9 73 Chenai Zinyuku 2 16-24s Louis Walsh 9 74 Kerry McGregor 3 Over 25s Sharon Osbourne 9 75 Futureproof 4 Groups Simon Cowell 9 76 Austin Drage 5 Boys Simon Cowell 9 77 Rachel Adedeji 6 Girls Dannii Minogue 9 78 Aiden Grimshaw 7 Boys Dannii Minogue 9 79 Johnny Robinson 8 Over 25s Louis Walsh 9 80 Phillip Magee 2 16-24s Louis Walsh 10 81 Dionne Mitchell 3 Over 25s Sharon Osbourne 10 82 Scott Bruton 5 Boys Simon Cowell 10 83 Miss Frank 6 Groups Louis Walsh 10 84 TreyC Cohen 7 Girls Cheryl Cole 10 85 The Risk 8 Groups Tulisa Contostavlos 10 86 Jade Ellis 9 Girls Tulisa Contostavlos 10 87 4Tune 2 Groups Simon Cowell 11 88 4Sure 3 Groups Louis Walsh 11 89 Daniel DeBourg 4 Over 25s Louis Walsh 11 90 Girlband 5 Groups Louis Walsh 11 91 Rikki Loney 6 Boys Cheryl Cole 11 92 Belle Amie 7 Groups Simon Cowell 11 93 Sophie Habibis 8 Girls Kelly Rowland 11 94 MK1 9 Groups Louis Walsh 11 95 Addictive Ladies 1 Groups Simon Cowell 12 96 The Unconventionals 2 Groups Louis Walsh 12 97 Kimberley Southwick 4 Girls Sharon Osbourne 12 98 Bad Lashes 5 Groups Louis Walsh 12 99 John Adeleye 7 Over 28s Louis Walsh 12 100 Sami Brookes 8 Over 25s Louis Walsh 12 101 Melanie Masson 9 Over 28s Gary Barlow 12 102 Diva Fever 2 Groups Simon Cowell 13 103 Nu Vibe 8 Groups Tulisa Contostavlos 13 104 Carolynne Poole 9 Over 28s Gary Barlow 13 105 Storm Lee 7 Over 28s Louis Walsh 14 106 F.Y.D. 7 Groups Simon Cowell 15 107 Wally Owl 10 Birds Wally Owl 15 108 Nicolo Festa 7 Boys Dannii Minogue 16

Dear Sir Pl guide. I have to get data from a closed workbook but that closed workbook is prepared based on retrieving data from CSV files with the help of power query. Every day a new CSV gets added. Hence before getting data from that closed workbook I have to refresh query in that workbook. Hence, is it possible to refresh that query with VBA code even if that workbook is closed? If the file is open, then I know that I can activate that workbook and use "Thisworkbook.RefreshAll". But I don't know if and how to refresh connections in a closed workbook. Pl. Guide REGARDS CHAITANYA

Terima kasih.

Hi Andrew, I must say this is one of the tutorials on string manipulation via VBA where I in recent six to 12 months extracted most of the knowledge you shared here with us in my work. Also other videos which deal with strings, I was able to extract most of gained knowledge, again thanks to you, of course few books are always helpful to have at hand. What I was really adamant at is to leave positive comment on using loop when it comes to splitting strings. I have watched this tutorial couple times in course of last two years, always reverting back to gather forgotten valuable information, but also to finally get behind the logic on larger scale of your do while loop when it comes splitting strings (32:32). It helped me applied this approach in my project and expand it for large data set with more than few conditions. I just wanted to say thank you for your effort and knowledge you share here with us and ask politely when possible I would be thankful to have the string split method via loop presented a bit deeper with more examples in one of you next videos perhaps. Do please keep posting videos on VBA. Thank you, all the best. 👍🍀

i really hope you'll do more videos on Report builder. There is no where else to find training on this software, even the online course websites out there on the internet don't have material on this

I just tried this and i get "DevToolsActivePort file doesn't exist" meaning chrome crashed, anyone how can help?

but after saving workbook, and you open it. It will show error and repair workbook. Then you will lost data model in workbook. My office version is office 365.

Thx for sharing. I copied your code to try it out, when I ran, it gave me an error message "Complie error. User-defined type not dfeined." on the first line of code "Dim sh As shell32.Shell". Can you please as what I need to do to have the shell32.dll be include to complue this code ?

Great tutorial - even I can follow it!! One question from me. You called this table ReleaseCalendar. (forgetting the lower and upper bounds for a moment) could this table not also be linked to any other date in the model? Assume you have a Sales table with Order Date, Ship Date, Invoice Date etc, can you not link this one table to all of them or do you need one per date column? (sorry if you covered that but I did not notice it)

Finally doing some coding with Userforms but having some trouble with listboxes. I have 2 listboxes on the form. I load the boxes with values from a data list on a worksheet. My trouble is that once I initialize the form and add values to the lists, one of the list boxes show a listbox.value of NULL. The other shows a listbox.value of "". They also behave differently when I try to set a default value in each (one accepts the default value, the other does not) but I can't see any difference in the way they are configured. I've tried deleting/recreating, with the same result. Any ideas?

how to display image

Very good explanation! This comment marks a 10 year anniversary of your tutorial ;-)

Question, not sure which video this would have been most relevant to post it in, but I've got a scenario I'm wondering if it is doable with Message Boxes. Is it possible to have a message box pop up as an event procedure say maybe upon opening a workbook and display only cells that have values in a given range as well as values of an adjacent column? So for example, if I want a message box to show only those cells that have values from Column I(Eye not L) and then the corresponding values in column C, could a message box do that as a vertical listing? So something like: John Smith - 100 Nancy Smith - 50 Paul Smith - 75 Would that be really complex to do something like that?

This man changed my life many many years ago with his SSRS tutorials :) I still watch them every now and again to feel a little bit of nostalgia! Good to hear your voice again on this topic.

Hey, thank you a lot for this course, I've got an issue when try to filter out a DataSet Dax Query based on a "Multi Value" parameter, it doesn't work. I didn't get this issue modifying the DataSet Dax Query through a single selection parameter. browsing what I've gotten is this:Since Report Builder does not directly handle multi-value parameters in DAX like SQL" @WiseOwlTutorials I appreciate if you give me an advice to make it work!

Please create more dax videos