How to use DATESBETWEEN DAX Function in Power BI // Beginners Guide to Power BI in 2021

Рет қаралды 11,011

Күн бұрын

Get Demo Files here
ko-fi.com/s/74c7d126c5
In this video were going to go through how to use the DATESBETWEEN DAX function, the basics of how to use it, and some of the more creative it can be used.
-
🚩 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 KZfaq.
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

Пікірлер: 14

@gintomino4136 2 жыл бұрын

You are a life saver! I've been looking for this! Very clear explanation and easy to follow. Thanks for sharing!

@isidrebague3659 2 жыл бұрын

Great explanation and very transparent!!. Thanks for sharing

@SolutionsAbroad 2 жыл бұрын

Glad it was helpful!

@veebee3969 9 ай бұрын

Thank you for the great video. In the calculation of last 3 days sales, how do you exclude weekend days? Appreciate your guidance.

@Littlepeanut9 Ай бұрын

I didn’t get the average function part. Is it supposed to be dividing by the total number of days.. ..?if it’s doing where it is?

@durgasmily.d.p5345 2 жыл бұрын

I found your videos Awesome. Can you please share the data set for every power Bi module in your channel?

@SolutionsAbroad 2 жыл бұрын

Hey there, thanks for watching! I've catalogued all of the datasets/reports in this onedrive folder:www.patreon.com/posts/demo-files-52538104 It's currently only available to patrons for a small fee, however once you sub, its lifetime access

@UlyssesHaq 2 жыл бұрын

This is POWERFUL! Thank you kindly for sharing. Looking forward to more. If i could request a video, only if u have time, i have a unique challenge where i have a typical budget spreadsheet, i have to unpivot, whiich puts month dates in each row - perfect - but then i need to sum the totals for each month, and add an addiitional amount in an adjacent using firstnonblank, but i only need to add this amount the total of the sum'ed amount. If that makes sense? Welcome to my nightmare. 🤭

@SolutionsAbroad 2 жыл бұрын

Hi Imran, thanks for watching! And indeed interesting challenge, it sounds like something that needs be dealt with in DAX, I'll put this on my list!

@simongiang 2 ай бұрын

Hi, I want to use the Year that the user select from the Year filter, how to use the selected Year in the DATE function? for example from the report user select Year filter = 2023 how to pass the selected Year to the function DATE below? Date Between = DATESBETWEEN('Calendar'[Date], DATE(Year, 1, 1), DATE(Year, 12,31))

@Aussiepeoplestats 7 ай бұрын

i am getting blank values for the same formula. how can this happen

@suryaprakash-hm1fe Жыл бұрын

Hello Fernan..!! , at 9:48(DATESBETWEEN as a relative) the calculation of Last 3 days measure was quite good , but when I cross check the ‘Total sales last 3 days’ values by each row in the video the values are not matching(Except for first 3 rows…i.e. £440 + £1863 + blank = £2303.4 ) Can you please clear this query for rest of the rows ?

@tsiferanaranaivoson1656 2 ай бұрын

yeah I confirm, it doesn't give us the total sales last 3 days.