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 ) )
@WiseOwlTutorials10 сағат бұрын
Hi! I think the video on context transition might help explain this kzbin.info/www/bejne/r5OcnnR5fraJmrMfeature=shared Hope it helps!
@bernardarhin26282 күн бұрын
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).
@WiseOwlTutorials10 сағат бұрын
Hi! It depends which set of Movies data you're using - this video only has a single table and doesn't include the Studio column. Are you using a version of Movies with a separate Studio table or one with a Studio column in the same table as the films?
@x15g2 күн бұрын
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?
@ican19723 күн бұрын
how did you guys get the access for the sql script and the apps table?
@IgnacioAguilarToledo4 күн бұрын
Great tutorial. Thank you!
@WiseOwlTutorials11 сағат бұрын
Thanks for watching and taking the time to leave a comment!
@dilawarali85694 күн бұрын
Very informative and great to solidify Power BI DAX Basics!
@WiseOwlTutorials11 сағат бұрын
Happy to hear that you found it useful, thanks for watching!
@PowerBILearner-c6d5 күн бұрын
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])?
@WiseOwlTutorials11 сағат бұрын
Hi! It's because you're referring to the [Date] column produced by the CALENDAR function, not the physical Date column in the Release Calendar table.
@HumbleThyself2305 күн бұрын
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!
@WiseOwlTutorials11 сағат бұрын
You are very welcome! Happy to hear you're finding it useful so far!
@parulsharma3305 күн бұрын
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
@WiseOwlTutorials11 сағат бұрын
Thank you so much for the kind comments and for watching!
@mangethezwane47298 күн бұрын
I think your voice should be used in all tutorials on YT😅. Thank you for all the great content.
@WiseOwlTutorials11 сағат бұрын
😀you are very welcome, thank you for watching!
@anilkumarp90559 күн бұрын
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.
@WiseOwlTutorials11 сағат бұрын
If you place Oscar Success in the y-axis you'll get the count of values produced by the calculated column for each genre. Hope it helps!
@anilkumarp90557 сағат бұрын
@@WiseOwlTutorials thank you 😊
@user-wt2wq9mb9t10 күн бұрын
Hi , can you please share the how to create = date year, 1 hour interval ?
@user-mq2vz5yh6g10 күн бұрын
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.
@WiseOwlTutorials10 күн бұрын
Hi! I wouldn't expect to be able to a stored procedure when connecting to a PBI Semantic Model, no. I don't know enough about Fabric Lakehouses to know whether it's possible there. I'd only expect to have access to a stored procedure if you connect directly to the SQL Server database. You could use stored procedures to populate the PBI semantic model. I'm not sure if that helps!
@vladmaiorov107211 күн бұрын
When we go to next page, we lose header, even though RepeatOnNewPage is set to true, how to fix that?
@WiseOwlTutorials10 күн бұрын
Hi! Try setting the KeepWithGroup property of the header row (it's just above the RepeatOnNewPage property) to After. Hope it helps!
@mohamedadjal-s2k11 күн бұрын
thinks 😀
@WiseOwlTutorials10 күн бұрын
You're welcome! 😀
@RohitSharma-uw2eh12 күн бұрын
Sir make dax playlist free plz
@gurvindersingharora530112 күн бұрын
Hello ! Why not start M Query Language playlist on your channel ?
@WiseOwlTutorials10 күн бұрын
Hi! It's on the To-Do list but there are only so many hours in a day!
@wli760512 күн бұрын
Best of all!
@WiseOwlTutorials10 күн бұрын
Thanks so much!
@g01den-draft13 күн бұрын
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 :(
@ArchStanton80613 күн бұрын
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
@WiseOwlTutorials10 күн бұрын
Hi! You're very welcome to paste your code here. Where are you seeing the - - result? And which version of Power BI are you using? I think that card visuals used to display blanks as - - by default in earlier versions of PBI.
@g01den-draft13 күн бұрын
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?
@niltondasilva517415 күн бұрын
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.
@WiseOwlTutorials13 күн бұрын
Unfortunately that's correct. A change to the Chromedriver made the SeleniumBasic library incompatible with this technique. You can roll back to an earlier version of Chrome but that's not an ideal solution.
@FlyingColors116 күн бұрын
Is SSRS still being worth learning, is in Use in current IT companies?
@WiseOwlTutorials13 күн бұрын
Hi! Companies still book SSRS courses with us in 2024.
@adepressedman715617 күн бұрын
Thanks WiseOwl. Please make a series on power bi data model.
@WiseOwlTutorials13 күн бұрын
You're welcome and thanks for the request!
@mohamedamro17 күн бұрын
Magnificent as usual. Greetings from Egypt.
@WiseOwlTutorials13 күн бұрын
Thank you for watching!
@x15g18 күн бұрын
Hey, what if you want to reference multiple columns from different tables in the ALLEXCEPT function? How would you do that please? Thank you
@WiseOwlTutorials13 күн бұрын
Hi! You can reference columns from other tables, for example: Total Run Time Oscars Only = CALCULATE( [Total Run Time], ALLEXCEPT( Film, Film[OscarNominations], Film[OscarWins], Country[Country] ) ) Is there something specific you're trying to do?
@x15g6 күн бұрын
@@WiseOwlTutorials Thank you!
@jaimec311618 күн бұрын
Why when I use insert into with ado all data when is store save like '8
@WiseOwlTutorials13 күн бұрын
I don't know, what does your code look like?
@hijinxcorex18 күн бұрын
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?
@WiseOwlTutorials13 күн бұрын
Hi! I'm not sure if this is the answer you're looking for but the outer join described in the Dataset part of the video shows how you can return films which don't have a country assigned to them. In the first table you can see No Country for Old Men which has a null CountryID in the Film table. Is that what you meant?
@BBLENDER18 күн бұрын
Thanks!
@WiseOwlTutorials13 күн бұрын
You're welcome, thanks for watching!
@omidmehdi19 күн бұрын
That is such an epic video like the rest of your videos
@WiseOwlTutorials13 күн бұрын
Ah thanks so much! Happy to hear that you liked it and thanks for your support!
@antwanto19 күн бұрын
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
@chaitanyajoshi69019 күн бұрын
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
@Melki20 күн бұрын
Terima kasih.
@WiseOwlTutorials20 күн бұрын
Thank you so much!
@deninsrmic416521 күн бұрын
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. 👍🍀
@WiseOwlTutorials20 күн бұрын
Thanks so much, it's great to hear that this video has helped you! Thanks for taking the time to write such a nice comment and for watching!
@rtecunit60221 күн бұрын
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
@WiseOwlTutorials20 күн бұрын
Thanks! Happy to hear that you found the Report Builder videos useful! I'd like to add more videos on indicators, gauges, charts, lists, maps and working in the SSRS web portal.
@shummidoo22 күн бұрын
I just tried this and i get "DevToolsActivePort file doesn't exist" meaning chrome crashed, anyone how can help?
@WiseOwlTutorials20 күн бұрын
Sorry I haven't encountered this problem before. StackOverflow has several threads on this error message which might help.
@FashionCobalt22 күн бұрын
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.
@WiseOwlTutorials20 күн бұрын
It still works as normal in Office 365 for me. I'm sorry I don't know why you encounter this problem.
@FashionCobalt19 күн бұрын
@@WiseOwlTutorials Thank you. It's normal now, but I'm not sure what exactly happened. It just suddenly became normal。 by the way , do you know it is possible to add a calculated column in data model through VBA? it seems that ModelTables hasn't method add column.
@WiseOwlTutorials19 күн бұрын
@@FashionCobalt I don't know of a way to do that, but you should be able to replicate what you want to do with a calculated column by creating a measure instead.
@Mohairp5322 күн бұрын
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 ?
@Mohairp5322 күн бұрын
Disgred as I fixed my own problem. thx
@WiseOwlTutorials20 күн бұрын
Hello! Near the beginning of the video (around 1:06) it shows how to reference the Microsoft Shell Controls and Automation library. Hope it helps!
@WiseOwlTutorials20 күн бұрын
@@Mohairp53 Happy to hear that you fixed it!
@seantame586522 күн бұрын
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)
@WiseOwlTutorials20 күн бұрын
Hi! Yes, we do have a video on using single calendars or multiple calendars (although it's a subscriber-only video at the moment) kzbin.info/www/bejne/bJaVXo2LlJJpfdkfeature=shared You can see the full DAX playlist here kzbin.info/aero/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX&feature=shared
@stephenhammond174523 күн бұрын
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?
@WiseOwlTutorials20 күн бұрын
Hi! I'd need to know more about how you're populating the listboxes and trying to retrieve the value!
@stephenhammond174520 күн бұрын
I populate the listboxes in the userform_initialize event from values in a worksheet using a for-each loop. Works fine. After the loop I then try to set both listbox.value properties to values from the same worksheet range.(I do this so if the user does not select a value then the listbox.value won't be an empty string). If I run the code and hover over the listbox.value properties before I try to set them, but after the listsboxes have been populated, one of the listbox.values is set to "NULL", the other is set to an empty string"". After I try to set the values, the one that started out as "NULL" accepts the value, the other does not but still shows an empty string. SO, I guess what I really want to know is how to set a default value for a listbox. PS. It also does not work if I set a value in the listbox properties window.
@WiseOwlTutorials19 күн бұрын
@@stephenhammond1745 Hi, I don't know why this isn't working for you. If I populate a listbox using either cells in the worksheet or using the AddItem method like this: Me.ListBox1.AddItem "Action" Me.ListBox1.AddItem "Adventure" Me.ListBox1.AddItem "Animation" I can set the value of the listbox to Adventure either like this: Me.ListBox1.Value = "Adventure" Or like this (the list items are indexed from 0): Me.ListBox1.Selected(1) = True Let me know what happens!
@stephenhammond174519 күн бұрын
@@WiseOwlTutorials Ok, thanks. The first method works for 1 listbox but not the other. The only difference from what you've shown is that I didn't name the userform when setting the listbox.value. I've tried recreating and renaming both boxes with the same result. Very strange. If I ever figure it out I'll let you know. Thanks for your help.
@stephenhammond174519 күн бұрын
@@WiseOwlTutorials Another piece of the puzzle. It seem that whatever listbox.value I try to set first in the code defaults to a "" value and the second defaults to a NULL value. If I reverse the order in the code, the same thing happens: first gets "" and second gets NULL. So, after populating the listboxes (which works fine by the way) the next 2 lines of code are: Me.listbox1.value = "test1" Me.listbox2.value = "test2". before this code executes, (hover cursor) Listbox1.value is "" Listbox2.value is NULL After the code executes listbox1.value is "" listbox2.value is test2 if I reverse the order in the code then listbox2 gets "" and listbox1 gets "test1".
@NguyenVanThang197924 күн бұрын
how to display image
@WiseOwlTutorials20 күн бұрын
Hi! You can insert an Image control and either import a file or link it to a URL.
@allardbon196725 күн бұрын
Very good explanation! This comment marks a 10 year anniversary of your tutorial ;-)
@WiseOwlTutorials20 күн бұрын
Thanks! And a belated Happy Birthday to the video 😀
@bhar285525 күн бұрын
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?
@WiseOwlTutorials20 күн бұрын
Hi! It's not super complicated, no. One option would be as follows: Use the Workbook_Open event to trigger the code when the workbook opens kzbin.info/www/bejne/Zna7lYOZl9iHkKsfeature=shared Add a For Each loop to look at each cell in the appropriate range of column I kzbin.info/www/bejne/fKjGdnl5rKynoNEfeature=shared Use an If statement to check if each cell has a value kzbin.info/www/bejne/j4iudqGNfMuXr7Mfeature=shared Use the Offset property to retrieve the related value from column C kzbin.info/www/bejne/oZaplpZud6lrqtkfeature=shared Use a variable to build up the list of values adding a new line for each item kzbin.info/www/bejne/j57Sdo2Gjd6mgqMfeature=shared Display the results in a message box at the end. A basic version of the code would be something like: Dim ListOfNames As String Dim rng As Range ListOfNames = "LIST OF POPULATED CELLS" For Each rng In Worksheets("Sheet1").Range("I2:I10") If rng.Value <> "" Then ListOfNames = ListOfNames & vbNewLine & rng.Offset(0, -6).Value & vbTab & rng.Value End If Next rng MsgBox ListOfNames, vbInformation Hope it helps!
@bhar285520 күн бұрын
@@WiseOwlTutorials Thank you so much!!!
@WiseOwlTutorials20 күн бұрын
@@bhar2855 You're welcome!
@pnr8uk26 күн бұрын
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.
@WiseOwlTutorials20 күн бұрын
Thanks so much! Really happy to hear that the SSRS videos were so useful and pleased to hear that you're enjoying the DAX videos too!
@victhorc.f.222326 күн бұрын
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!
@WiseOwlTutorials20 күн бұрын
Hi! You might find this article useful blog.crossjoin.co.uk/2019/11/03/power-bi-report-builder-and-rscustomdaxfilter/ I hope it helps!