Calculate Month on Month, Day on Day, Year on Year using DAX // Beginners Guide to Power BI in 2021
HTML-код
- Опубликовано: 8 июл 2024
- Get Demo Files here
ko-fi.com/s/43fbe0b818
In this video were going to go through how to calculate Day on Day, Month on Month and Year and Year easily using DAX.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RUclips.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence
You sir just put an end to my 3h of searching for a video/article that will explain in detail how is this achieved! Thank you so so much!!
Hi and thanks for all the content you share. What if I want to compare January to every other month and get the % of change between Jan and other months in the particular year?
This is just what I needed but my situation is I want to compare current year monthly to last year monthly and shows the difference in percentage. I can't use 'previousmonth', what should I use to get the previous year monthly? Thanks for your help as always.
Thanks, it helped me a lot!
Great video, Is there a way we can see Pervious year data and next to that we see the current year data
there is literally a Quick Measure to do this built into Power Bi.
Great video, what about if I want to compare % change of 3 months interval. For instance % change between July and September
Thanks for watching! In this case you'll probably need a different solution, you can try this one I covered recently which uses DATESINPERIOD ruclips.net/video/_UV_PgtKhWk/видео.html
While entering DAX function which key you press for moving to next line .
Hello There,
Its explained very well.Thanks
Actually I am having Query that if i have 2 years data i want to show that MOM value for first month of each year should be same as actual but in my case it is taking
=YTD value of Previous Year (2022)- January 2023 = giving wrong result
it must take January 2023 as it is when i select year 2023 and also for 2022
Could please help on the same.
if required more details please let me know
do we need the dates from calendar table or can I get it from my fact tbale itself
?
As, I have data till march but its comparing for April as well and summing it to 0 (for MOM comparison )
Please how will you do that for a week on week change? Weekday starts from Monday
Nice video, how can we restrict it use only single year, though I have selected a single year as 2021 in the slicer, but still Jan 2021 compares the values with Dec 2020. Is there a way to restrict only selected year ? Jan 2021 should be blank
Hi Vijay, it sounds like you'll need to wrap the whole measure with IF(NOT(ISBLANK(), [Measure here])) This makes sure any rows without any values will be excluded
I am calculating the previous month sales and difference comparing with current and previous month but I get blank values in the column. How it is possible? This previousmonth function is not working for me.
How can you compare Month to Date (MTD) vs. Last Month to Date (LMTD) where the reflection and visualization of data shall be based on the current date TODAY(). Thanks.
This is really interesting Ahmed, I will cover it in a video as I'm also curious what this would look like!
Hello,
I have a questions regaring Day on Day fuction - i understand why BLANKs showed up but is there any way that if we don't have a data from PreviousDay our measuer will take next No Blank value?
Btw thanks for your videos that was a milestone for me :)
Hi there, of course! For this case, you'll need to use the IF statement to check if the value is empty, then show blank (or usually ZERO)
Hi Sir,
Here if we select current year (2021) then it shows current month (Jan 2021) minus previous month (Dec 2022). but i want to show that if i select current year it will show same value for 1st month that is Jan 2021 without previous month value?
can you tell us how to do it?
if anyone here knows it they can help me
thanks in advance
I just have one metric I want to do this for so example; I don't use 'quantity x price', but just 'quantity'. However, I did these steps for one metric (used SUM instead of SUMX ) which works to mimic the same values as the original 'quantity' values, however next step with 'last month' calculation does not work (no values are shown). Tips anyone?
What about the Month compared to last year's same month?
Hi there, there is a DAX function called PARALLELPERIOD that will allow you to do this: docs.microsoft.com/en-us/dax/parallelperiod-function-dax
please provide files also
Hi Thambi, the files are all available to download through my Patreon: www.patreon.com/posts/demo-files-52538104