Calculate Difference This Year vs Last Year in Power BI with DAX
283.4 هزار بار بازدید -
7 سال پیش
-
Check out the 2022 update
Check out the 2022 update of this video here: Calculate Difference This Year vs Las...
Learn how to use DAX measures to work out the difference between calculated amounts this year versus last year. Get an intro into the concept of measure branching in DAX.
**** Video Details ****
0:24 - summing up revenue column
0:37 - total sales measure
1:46 - reviewing total sales information by date
2:34 - total sales last year
4:20 - difference between sales this year vs last year
5:42 - visualization of difference between sales this year vs last year
**** 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 - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Learn more about Enterprise DNA - http://www.enterprisedna.co/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
**** Related Links****
Calculating Percent Profit Margins Using DAX in Power BI - https://blog.enterprisedna.co/2019/01...
Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX - https://blog.enterprisedna.co/2018/12...
Calculate Consecutive Weekday & Weekend Days In Power BI Using DAX - https://blog.enterprisedna.co/2018/10...
**** Related Course Modules****
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time...
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...
DAX Formula Deep Dives - http://portal.enterprisedna.co/p/dax-...
**** Related Support Forum Posts****
SamePeriodLastYear returns this year selected period value - https://forum.enterprisedna.co/t/same...
Grand Total not working properly - https://forum.enterprisedna.co/t/gran...
Financial templates vs LastYear make sameperiod - https://forum.enterprisedna.co/t/fina...
For more SAMEPERIODLASTYEAR support queries to review see here - https://forum.enterprisedna.co/search...
Learn how to use DAX measures to work out the difference between calculated amounts this year versus last year. Get an intro into the concept of measure branching in DAX.
**** Video Details ****
0:24 - summing up revenue column
0:37 - total sales measure
1:46 - reviewing total sales information by date
2:34 - total sales last year
4:20 - difference between sales this year vs last year
5:42 - visualization of difference between sales this year vs last year
**** 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 - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Learn more about Enterprise DNA - http://www.enterprisedna.co/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
**** Related Links****
Calculating Percent Profit Margins Using DAX in Power BI - https://blog.enterprisedna.co/2019/01...
Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX - https://blog.enterprisedna.co/2018/12...
Calculate Consecutive Weekday & Weekend Days In Power BI Using DAX - https://blog.enterprisedna.co/2018/10...
**** Related Course Modules****
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time...
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...
DAX Formula Deep Dives - http://portal.enterprisedna.co/p/dax-...
**** Related Support Forum Posts****
SamePeriodLastYear returns this year selected period value - https://forum.enterprisedna.co/t/same...
Grand Total not working properly - https://forum.enterprisedna.co/t/gran...
Financial templates vs LastYear make sameperiod - https://forum.enterprisedna.co/t/fina...
For more SAMEPERIODLASTYEAR support queries to review see here - https://forum.enterprisedna.co/search...
7 سال پیش
در تاریخ 1396/02/22 منتشر شده
است.
283,481
بـار بازدید شده