WiseOwlTutorials
WiseOwlTutorials
  • 679
  • 29 159 091
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!
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?
Power Automate Part 7 - Conditions
zhlédnutí 1,6KPřed 8 měsíci
Power Automate Part 7 - Conditions
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?

Komentáře

  • @mostainbillah
    @mostainbillah Před 18 minutami

    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 .

  • @aoaoaoaoable
    @aoaoaoaoable Před 19 hodinami

    great video thanks. Pre-2016, how did multi-value selection work. Did you have to modify the WHERE clause with more parameter values?

  • @shaileshsharma668
    @shaileshsharma668 Před 2 dny

    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

  • @yosef-yosef9414
    @yosef-yosef9414 Před 2 dny

    Thank you SO much for this video

  • @ginolatino7081
    @ginolatino7081 Před 5 dny

    .. so it chopped 14 mins of the runtime of "Titanic" that can only be a good thing ain't it? ...Excellent😜

  • @csakegybolond264
    @csakegybolond264 Před 5 dny

    Thank you. Very nice. Can I do it without background?

  • @hafizullahsufi
    @hafizullahsufi Před 5 dny

    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...

  • @Melki
    @Melki Před 6 dny

    Terima kasih.

  • @purple001100
    @purple001100 Před 7 dny

    How do create a header with logo, string format and table in Word using VBA ?

  • @potatoKAMI
    @potatoKAMI Před 9 dny

    Such nice explanations ❤❤ and twilight sucks.

  • @redangrybird7564
    @redangrybird7564 Před 9 dny

    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. 😎👍

  • @yo_eduard
    @yo_eduard Před 9 dny

    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?

  • @mePrafull
    @mePrafull Před 10 dny

    Thank you

  • @mePrafull
    @mePrafull Před 10 dny

    Thank you

  • @alanrobbo6980
    @alanrobbo6980 Před 11 dny

    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.

  • @jasminparmar3394
    @jasminparmar3394 Před 11 dny

    In my Laptop, cell reference does not lock with switching F4. Then what to do?

  • @AhmedAbdalalim
    @AhmedAbdalalim Před 12 dny

    That is helpful, thank you so much

  • @claudiozadorosny4722
    @claudiozadorosny4722 Před 12 dny

    Great video. Helping me 5 years later

  • @x15g
    @x15g Před 14 dny

    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 ) )

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      Hi! I think the video on context transition might help explain this czcams.com/video/yb9mACIQVdQ/video.htmlfeature=shared Hope it helps!

  • @bernardarhin2628
    @bernardarhin2628 Před 15 dny

    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).

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      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?

  • @x15g
    @x15g Před 15 dny

    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?

  • @ican1972
    @ican1972 Před 16 dny

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

  • @IgnacioAguilarToledo
    @IgnacioAguilarToledo Před 16 dny

    Great tutorial. Thank you!

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      Thanks for watching and taking the time to leave a comment!

  • @dilawarali8569
    @dilawarali8569 Před 16 dny

    Very informative and great to solidify Power BI DAX Basics!

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      Happy to hear that you found it useful, thanks for watching!

  • @PowerBILearner-c6d
    @PowerBILearner-c6d Před 17 dny

    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])?

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      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.

  • @HumbleThyself230
    @HumbleThyself230 Před 17 dny

    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!

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      You are very welcome! Happy to hear you're finding it useful so far!

  • @parulsharma330
    @parulsharma330 Před 18 dny

    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

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      Thank you so much for the kind comments and for watching!

  • @mangethezwane4729
    @mangethezwane4729 Před 20 dny

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

  • @anilkumarp9055
    @anilkumarp9055 Před 22 dny

    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.

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 13 dny

      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!

    • @anilkumarp9055
      @anilkumarp9055 Před 12 dny

      @@WiseOwlTutorials thank you 😊

  • @user-wt2wq9mb9t
    @user-wt2wq9mb9t Před 22 dny

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

  • @user-mq2vz5yh6g
    @user-mq2vz5yh6g Před 23 dny

    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.

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 23 dny

      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!

  • @vladmaiorov1072
    @vladmaiorov1072 Před 23 dny

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

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 23 dny

      Hi! Try setting the KeepWithGroup property of the header row (it's just above the RepeatOnNewPage property) to After. Hope it helps!

  • @mohamedadjal-s2k
    @mohamedadjal-s2k Před 24 dny

    thinks 😀

  • @RohitSharma-uw2eh
    @RohitSharma-uw2eh Před 25 dny

    Sir make dax playlist free plz

  • @gurvindersingharora5301

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

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 23 dny

      Hi! It's on the To-Do list but there are only so many hours in a day!

  • @wli7605
    @wli7605 Před 25 dny

    Best of all!

  • @g01den-draft
    @g01den-draft Před 25 dny

    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 :(

  • @ArchStanton806
    @ArchStanton806 Před 25 dny

    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

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 23 dny

      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-draft
    @g01den-draft Před 25 dny

    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?

  • @niltondasilva5174
    @niltondasilva5174 Před 27 dny

    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.

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 26 dny

      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.

  • @FlyingColors1
    @FlyingColors1 Před 28 dny

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

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 26 dny

      Hi! Companies still book SSRS courses with us in 2024.

  • @adepressedman7156
    @adepressedman7156 Před měsícem

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

  • @mohamedamro
    @mohamedamro Před měsícem

    Magnificent as usual. Greetings from Egypt.

  • @x15g
    @x15g Před měsícem

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

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 26 dny

      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?

    • @x15g
      @x15g Před 18 dny

      @@WiseOwlTutorials Thank you!

  • @jaimec3116
    @jaimec3116 Před měsícem

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

  • @hijinxcorex
    @hijinxcorex Před měsícem

    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?

    • @WiseOwlTutorials
      @WiseOwlTutorials Před 26 dny

      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?

  • @BBLENDER
    @BBLENDER Před měsícem

    Thanks!