Calculate Fiscal Year for a Date Dimension using DAX with Power BI

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=uvMe1_76ZVQ

Published on Nov 25, 2021: • In this video, we will learn to calculate the Fiscal Year from the Date dimension. The DAX code for the same is: • DimDate = Addcolumns(CALENDARAUTO(), Month Full Name ,FORMAT([Date], mmmm ), Calendar Year ,Year([Date]), FiscalYear ,IF(MONTH([Date])less tha equal to symbol here 6,Year([Date])-1,YEAR([Date]))) • In the previous video, we learnt to create a year to date fiscal year running total using DAX DATESYTD function. • The code for the same is: • SalesAmountYTD = CALCULATE(sum(FactInternetSales[SalesAmount]),DATESYTD(DimDate[FullDateAlternateKey].[Date], 06/30 )) • Previous Video: • Create a Basic date dimensin using da... • SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!! • / @learnexcelrelentless • • Download M Query code: • http://bit.ly/3kJwUUq • • Our Playists: • Extract Load and Transform data using Power Query: http://bit.ly/3orLRf4 • Enhance Power BI Data model using DAX: https://bit.ly/2GbTENc • Python and Power BI:https://bit.ly/2EajdNc • Getting Started with AWS: https://bit.ly/2PgSCQX • SQL Playlist :https://goo.gl/PS5Ep6 • DAX PlayList : https://goo.gl/S4W41D • Power BI PlayList: https://goo.gl/dXxvnB • Power Query Playlist: https://goo.gl/5QS7P4 • Getting Started with Power BI:https://goo.gl/GHakLZ • Getting Started with Python: https://goo.gl/n24P3w • Data Science With Python:https://goo.gl/PeYCR5 • Power BI service: http://tiny.cc/sjekmz • Data Modelling with Power BI:https://tinyurl.com/8b4srjrm • • ABOUT DAGDOO: • Website: • Home Page: http://www.dagdoo.org/ • Power BI Tutorials: http://www.dagdoo.org/excel-learning/... • • Questions? Comments and SUGESTIONS? You will find me here: • Twitter: @dagdooe • Category: Science Technology • License: Standard YouTube License

#############################

New on site