Calculating Sales Financial Year to Date in Power BI with DAX

Published: 14 May 2017
on channel: Enterprise DNA

40,237

255

Check out the 2022 update of this video here: • Calculating Sales Financial Year To D...

Find out how to get financial year to date calculations in Power BI with DAX. A simple formula that can produce great insight fast.

**** Video Details ****
0:46 Creating Total Sales Table
2:00 Calculating Sales Year To Date
3:20 Changing Calculation To Sales Financial Year To Date
4:36 Creating A Visualisation For The Existing Calculation

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links****
Filter Your Data By Unique Financial Years & Quarters – Power BI Modeling Technique - https://blog.enterprisedna.co/2018/10...
How To Create Unique Financial Year Quarters In Power BI - https://blog.enterprisedna.co/2018/07...
Month to Date (MTD) To Today’s Actual Date In Power BI Using DAX - https://blog.enterprisedna.co/2018/06...

**** Related Course Modules****
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time...
Business Analytics Series - http://portal.enterprisedna.co/p/busi...
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...

**** Related Support Forum Posts****
Dashboard Chart Selection Date to drive Sales YTD and Sales LY YTD - https://forum.enterprisedna.co/t/dash...
YTD and PYTD issue, potentially using the EDATE function somehow? - https://forum.enterprisedna.co/t/ytd-...
Estimate Calculation (actuals + remaining budget) - https://forum.enterprisedna.co/t/esti...
For more DATESYTD support queries to review see here - https://forum.enterprisedna.co/search...

Watch video Calculating Sales Financial Year to Date in Power BI with DAX online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 14 May 2017. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 40,237 times and liked it 255 visitors.