- 679
- 29 159 091
WiseOwlTutorials
United Kingdom
Registrace 21. 10. 2011
Software training videos from a leading UK-based training company. Learn useful techniques in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access, Microsoft PowerPoint, Microsoft Word and more!
DAX for Power BI Part 7.2 - Creating a Financial Year Calendar
By Andrew Gould
Download files here www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-basic-calendar/
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin
Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video shows you how to create a calendar table using DAX which includes a financial year, quarter and month column. You'll see how to calculate thes values using the AddColumns and Calendar tables, as well as how to use the calendar in measures with some of DAX's time intelligence functions.
Chapters
00:00 Topic list
00:49 The Data Model
02:17 The CalendarAuto Function
04:38 The Calendar Function
06:26 Using a Variable for the Start Month
08:39 Calculating the Start and End Year
12:59 Calculating Date Parts
14:55 Calculating the Financial Year
18:32 Calculating the Financial Month
20:52 Calculating the Financial Quarter
22:14 Using the Financial Year Calendar
25:36 Calculating Year to Date over Financial Years
27:12 The PreviousYear Function
28:48 DatesBetween, StartOfYear and EndOfYear Functions
30:21 Calculating the Percentage of Year Total
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!
Download files here www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-basic-calendar/
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin
Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video shows you how to create a calendar table using DAX which includes a financial year, quarter and month column. You'll see how to calculate thes values using the AddColumns and Calendar tables, as well as how to use the calendar in measures with some of DAX's time intelligence functions.
Chapters
00:00 Topic list
00:49 The Data Model
02:17 The CalendarAuto Function
04:38 The Calendar Function
06:26 Using a Variable for the Start Month
08:39 Calculating the Start and End Year
12:59 Calculating Date Parts
14:55 Calculating the Financial Year
18:32 Calculating the Financial Month
20:52 Calculating the Financial Quarter
22:14 Using the Financial Year Calendar
25:36 Calculating Year to Date over Financial Years
27:12 The PreviousYear Function
28:48 DatesBetween, StartOfYear and EndOfYear Functions
30:21 Calculating the Percentage of Year Total
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!
zhlédnutí: 1 501
Video
Wise Owl Answers - How do I copy slides from multiple PowerPoint files into one presentation in VBA?
zhlédnutí 827Před měsícem
By Andrew Gould Download files here www.wiseowl.co.uk/vba-macros/videos/vba-referencing-applications/vba-copy-powerpoint-slides/ If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a do...
DAX for Power BI Part 7.1 - Creating Basic Calendar Tables in DAX
zhlédnutí 1,6KPřed měsícem
By Andrew Gould Download files here www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-basic-calendar/ If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching...
Wise Owl Answers How do I save a shape as a picture in Excel VBA
zhlédnutí 832Před měsícem
By Andrew Gould Annoyingly, there's no quick, built-in way to save a shape object as a picture in Excel VBA, even though you can use a context menu option to do this easily in Excel! This video shows a slightly messy workaround in VBA which involves copying the shape into a temporary chart to make use of its Export method! If you'd like to help fund Wise Owl's conversion of tea and biscuits int...
Wise Owl Answers - How do I hide columns using parameters in SSRS?
zhlédnutí 875Před měsícem
By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! This video shows you three ways to allow an end user to control the visibility of co...
Power Automate Part 13a - Automating Forms
zhlédnutí 1,2KPřed měsícem
By Andy Brown You can download any files you'll need for this tutorial at www.wiseowl.co.uk/power-automate/videos/power-automate-server/forms/ (click on the Files tab), although you shouldn't need any. If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.html...
DAX for Power BI Part 6.4 - Opening and Closing Balance Calculations
zhlédnutí 2,3KPřed měsícem
By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Download files here www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-opening-closin...
Power Automate Part 12 - Approvals
zhlédnutí 1,8KPřed 3 měsíci
By Andy Brown You can download any files you'll need for this tutorial at www.wiseowl.co.uk/power-automate/videos/power-automate-server/approvals/ (click on the Files tab), although you shouldn't need any. If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw....
Power Automate Part 11 - Error Handling
zhlédnutí 1,7KPřed 4 měsíci
By Andy Brown You can download the files you'll need for this tutorial at www.wiseowl.co.uk/power-automate/videos/power-automate-server/error-handling/ (click on the Files tab). If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click th...
DAX for Power BI Part 6.3 - Calculating Running Total or To Date Values
zhlédnutí 4,3KPřed 7 měsíci
By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Download files here www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-to-date/ This ...
Power Automate Part 10 - Apply to Each loops
zhlédnutí 3,6KPřed 7 měsíci
By Andy Brown You can download the files you'll need for this tutorial at www.wiseowl.co.uk/power-automate/videos/power-automate-server/apply-to-each-loop/ (click on the Files tab). If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can clic...
DAX for Power BI Part 6.2 - Comparing Date Ranges
zhlédnutí 4,4KPřed 8 měsíci
By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Download files here www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-compare-date-r...
Power Automate Part 9 - Sorting and Filtering using OData
zhlédnutí 3KPřed 8 měsíci
By Andy Brown You can download the files you'll need for this tutorial at www.wiseowl.co.uk/power-automate/videos/power-automate-server/odata/ (click on the Files tab). If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link w...
DAX for Power BI Part 6.1 - Introduction to Time Intelligence Functions
zhlédnutí 6KPřed 8 měsíci
By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Download files here www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-intro-time-int...
Power Automate Part 8 - Working with tables
zhlédnutí 3,1KPřed 8 měsíci
By Andy Brown You can download the files you'll need for this tutorial at www.wiseowl.co.uk/power-automate/videos/power-automate-server/table-html-excel-sharepoint/ (click on the Files tab). If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: czcams.com/channels/bi5G5PjWBaQUFy7XU_O7yw.htmljoin Or you...
Wise Owl Answers - How do I draw a line in a cell in Excel VBA?
zhlédnutí 2,7KPřed 8 měsíci
Wise Owl Answers - How do I draw a line in a cell in Excel VBA?
Wise Owl Answers - How do I calculate aggregates for recursive groups in SSRS?
zhlédnutí 934Před 8 měsíci
Wise Owl Answers - How do I calculate aggregates for recursive groups in SSRS?
Power Automate Part 6 - Tidying Up Flows
zhlédnutí 1,2KPřed 8 měsíci
Power Automate Part 6 - Tidying Up Flows
Wise Owl Answers - How do I calculate percentage of columns in a matrix with multiple groups?
zhlédnutí 1,4KPřed 9 měsíci
Wise Owl Answers - How do I calculate percentage of columns in a matrix with multiple groups?
Power Automate Part 5 - Variables and Basic Arrays
zhlédnutí 3,6KPřed 9 měsíci
Power Automate Part 5 - Variables and Basic Arrays
Wise Owl Answers - How do I refer to the previous column in a matrix in SSRS?
zhlédnutí 1,1KPřed 9 měsíci
Wise Owl Answers - How do I refer to the previous column in a matrix in SSRS?
Power Automate Part 4 - The Compose action and debugging
zhlédnutí 2,8KPřed 10 měsíci
Power Automate Part 4 - The Compose action and debugging
Wise Owl Answers - How do I compare specific columns in a matrix in SSRS?
zhlédnutí 1,4KPřed 10 měsíci
Wise Owl Answers - How do I compare specific columns in a matrix in SSRS?
Power Automate Part 3 - Creating triggered flows
zhlédnutí 2,3KPřed 10 měsíci
Power Automate Part 3 - Creating triggered flows
Wise Owl Answers - How do I sort tables on multiple sheets in Excel VBA?
zhlédnutí 2,9KPřed 10 měsíci
Wise Owl Answers - How do I sort tables on multiple sheets in Excel VBA?
Power Automate Part 2 - Creating Basic Flows
zhlédnutí 3,8KPřed 11 měsíci
Power Automate Part 2 - Creating Basic Flows
DAX for Power BI Part 5.4 - Removing Filters with AllSelected and AllExcept
zhlédnutí 6KPřed 11 měsíci
DAX for Power BI Part 5.4 - Removing Filters with AllSelected and AllExcept
Power Automate Part 1 - Power Automate Desktop versus Server
zhlédnutí 9KPřed 11 měsíci
Power Automate Part 1 - Power Automate Desktop versus Server
Wise Owl Answers - How do I import tab delimited files with ActiveX Data Objects?
zhlédnutí 2KPřed 11 měsíci
Wise Owl Answers - How do I import tab delimited files with ActiveX Data Objects?
Hi , I Have seen Your tutorial , But I have need to select Next Empty Cell Between Two data In A column , Could You Provide the Suggestion . It will help for me .
great video thanks. Pre-2016, how did multi-value selection work. Did you have to modify the WHERE clause with more parameter values?
Hello sir Is there any way I can connect the ms access database from Excel vba but my database is stored in SharePoint plz help
Thank you SO much for this video
.. so it chopped 14 mins of the runtime of "Titanic" that can only be a good thing ain't it? ...Excellent😜
Thank you. Very nice. Can I do it without background?
Is there an Event something like After_Send? I want to check the Outbox for stuck messages - which seems to happen a lot more in recent Olk versions...
Terima kasih.
How do create a header with logo, string format and table in Word using VBA ?
Such nice explanations ❤❤ and twilight sucks.
Anddew: How can I write into a file a property with a different value, for example, change the date of creation and so forth? Thanks, very good video. 😎👍
Awesome tutorial! question = is there anway to just display an item with the total of lines next to it, not like you did as a total row?
Thank you
Thank you
Hi, I have managed to Extract the Info I Want, I now Wish to add a Comments (No.24) on the Spreadsheet. How do I Save this 'new data' to the Files properties ? The line {fol.GetDetailsOf(fil, 24)} gets the Data, But I can't find {fol.PutDetailsOf(fil, 24)} If you can Point me in the right direction id be very pleased.
In my Laptop, cell reference does not lock with switching F4. Then what to do?
That is helpful, thank you so much
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 ) )
Hi! I think the video on context transition might help explain this czcams.com/video/yb9mACIQVdQ/video.htmlfeature=shared Hope it helps!
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! 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?
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!
Thanks for watching and taking the time to leave a comment!
Very informative and great to solidify Power BI DAX Basics!
Happy to hear that you found it useful, thanks for watching!
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])?
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.
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!
You are very welcome! Happy to hear you're finding it useful so far!
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
Thank you so much for the kind comments and for watching!
I think your voice should be used in all tutorials on YT😅. Thank you for all the great content.
😀you are very welcome, thank you for watching!
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.
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!
@@WiseOwlTutorials thank you 😊
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.
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!
When we go to next page, we lose header, even though RepeatOnNewPage is set to true, how to fix that?
Hi! Try setting the KeepWithGroup property of the header row (it's just above the RepeatOnNewPage property) to After. Hope it helps!
thinks 😀
You're welcome! 😀
Sir make dax playlist free plz
Hello ! Why not start M Query Language playlist on your channel ?
Hi! It's on the To-Do list but there are only so many hours in a day!
Best of all!
Thanks so much!
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
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.
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.
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.
Is SSRS still being worth learning, is in Use in current IT companies?
Hi! Companies still book SSRS courses with us in 2024.
Thanks WiseOwl. Please make a series on power bi data model.
You're welcome and thanks for the request!
Magnificent as usual. Greetings from Egypt.
Thank you for watching!
Hey, what if you want to reference multiple columns from different tables in the ALLEXCEPT function? How would you do that please? Thank you
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?
@@WiseOwlTutorials Thank you!
Why when I use insert into with ado all data when is store save like '8
I don't know, what does your code look like?
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?
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?
Thanks!
You're welcome, thanks for watching!