Calculate MoM growth - period variance using Power BI DAX |

Рет қаралды 614

Күн бұрын

Learn how to use #powerbi #dax to calculate mom growth or decline using a measure. #analytics
We will use the PREVIOUSMONTH function to create a measure for comparison.
Download sample file
efficiency365.com/wp-content/...
Contents 📚
00:00 - Intro
00:40 - Create Matrix visual
00:51 - Add Dates and Drill down to month
01:11 - Add Total Amount Measure
02:31 - Calculate last month amount
03:32 - Calculate growth percentate
04:42 - Format the measure
05:06 - Add conditional formatting
Related videos 📺
Pivot Table Date Tutorial: How to group Dates by Fiscal Years and Quarters using VLOOKUP - • Pivot Table Date Tutor...
Daily opening and closing balance by product - Excel and Power BI - DAX - • Daily opening and clos...
Everything About Conditional formatting in MS Excel - • Everything About Condi...
Handle millions of rows in Excel - Large slow files? - use Data Model - • Handle millions of row...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)

Пікірлер: 4

@JosephFallon 18 күн бұрын

That's some great stuff - thank you !

@efficiency365 16 күн бұрын

Thanks @JosephFallon Check out my other best practices videos as well. Task Management Best Practices - kzfaq.info/get/bejne/erCTq7Ol2pPWk5s.html Efficient Tasks Management using the New Planner 2024 - kzfaq.info/get/bejne/oc2opN11ztjbYaM.html Microsoft Teams Meetings - 16 Best Practices - kzfaq.info/get/bejne/oplyqdRerpbMqWg.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html OneDrive Best Practices Part 1 - kzfaq.info/get/bejne/ep2Kpcmhzb2YpqM.html Part 2 - kzfaq.info/get/bejne/pKyoabyC3cmRkmg.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Cheers. Doc.

@kalyanijog 18 күн бұрын

Sir can you make video on time series forecasting on stock prediction for real time data , can we represent data in candlestick pattern in BI?

@efficiency365 16 күн бұрын

Thanks @kalyanijog Great idea. Will work on it. Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc