How to compare SAME PERIOD LAST MONTH in Power BI using DAX // Beginners Guide to Power BI

Подписаться 45 тыс.

Просмотров 38 тыс.

50% 1

Get Demo Files here
ko-fi.com/s/4d1e61f6e1
In this video were going to go through how you can calculate and compare cumulative values same period last month.
-
🚩 Get Demo Files here
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solutionsabroad/shop
solutionsabroad.co.uk/store
❤ Other ways to support
ko-fi.com/solutionsabroad
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 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 RU-vid.
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

Опубликовано:

11 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@winniedlaydy1013 2 года назад

Exactly what i needed. Thanks Fernan... from Ghana....

@doubleseatvlogs Год назад

It was really helpful.... thank a lot for sharing such real-life corporate requirements 🙂

@Terniedintorni Год назад

You are one of the best online. thanks

@SivaKumar-fv6lk Год назад

Thank you so much, very nice explanation.

@BhanuYadav-wg2rs Месяц назад

To the point video thanks a lot fernan❤

@marceloenlaoficina2236 Год назад

Thank you so much for your videos !!

@SolutionsAbroad Год назад

Thanks for watching them!

@andrey_shch 8 месяцев назад

Thank you!!!

@felixgaince6303 2 года назад

Thanks so much !

@SolutionsAbroad 2 года назад

You're welcome!

@jiranansupawong7472 Год назад

Thanks

@aahadal 3 месяца назад

Thank you

@Gua10ify Год назад

thank you

@sitiauniamaram3422 Год назад

Thank you this help me alot. Is it possible to this manually other than using time intelligence function ?

@shivamsatija3318 Год назад

Hey, Great Video. But this dateadd function has a problem. Whenever, I select date from 21st Apr'22 - 30th Apr'22 for sum of sales, date add gives me a sum of values from 21st Mar'22 - 31st Mar'22 (End of month) Technically, I want to compare sales from 21st Apr'22 - 30th Apr'22 v/s 21st Mar'22 - 30th Mar'22 Can u please assist me a little here.

@arnaudquirin2165 2 года назад

Thank you this helped me a lot. I did the same thing from Jan to Apr however when I filter on specific period the figures in the column SPLM disappear. Any suggestion to tackle that ?

@SolutionsAbroad 2 года назад

Hi there, it's most likely because the filter context changes when you add a period filter to it. The easiest fix to this is to create the calculations as a new column, it's not the most elegant but it will fix your issue Hope it helps

@LoNeGhEtTo 2 дня назад

Hi there, Jan has 31 days and Feb has 28, how do you deal with this with the SPLM? Wouldn't SPLM only compare data up to 28 Jan only instead of the entire Jan.

@hoaithuongluu2869 9 месяцев назад

Great video, but as far as I know, dateadd will always pick a given period till the end of the month. Let's say if we chose a period in apr from apr 23 to apr 30 and computong same previous last month, the result is data in march but computing from mart 23 to mar 31 (not mar 30) is there any other solutions for this case ?

@trishlasutaria7451 2 года назад

Hello. Thank you for the video. It is helpful. I am seeing an issue with SPLM. If I apply the filter top 1 by the latest date I get a blank count on the card.

@SolutionsAbroad 2 года назад

Hi there, does the correct value show up if you put it on a table? Perhaps its a row context issue

@gayatrilshinde1560 Год назад

How to solve this context issue

@manishamanhas6162 Год назад

Hey can you pls make video of time intelligence functions interview questions for beginners

@unitedwings7644 Год назад

Hey hi in powerbi I want to compare a value for continuous 15 mins if the value is same for 15mins continuously and I need a count 1 for that

@rephechaun Год назад

Hi Fernan, these are great videos. Thank you very much. I wonder is there a way to do DATEMTD but on working day, instead of calendar day For example, suppose 1 Feb 2022 is the 1st working day of Feb, same period last month of 1 Feb 2022 >> should be 2 Jan 2022, because 1 Jan is a public holiday, hence 2 Jan is the 1st working day of last month Basically, I'm looking for a way to calculate Same period last month by working days.. Hope anyone can help me here..i'm really stuck

@bennaniyusuf6845 4 месяца назад

how to create a slider that work for 3 charts should i combinate them with the date and hide the 2 date changer

@jeffmiller4405 8 месяцев назад

How did you filter for the current month? My visual display is the same until I attempt to filter. I tried filter for the current month and tried filtering if the Prior Month value is greater than 0 and it keeps excluding the prior month line graph.

@francescomantovani3936 Год назад

Oh, yeah.

@ramrajurkar4850 Год назад

Can u help me to create slicer for last day , last week/month/qtr/year

@phanvinh4501 11 месяцев назад

well, it doesn'twork if put it to a pivot table where ros are sales man and cols are some sales metrics like target, % achv and the col to see the ROLLING AMOUNT FOR THE SAME PERIOD LAST MONTH.