COMPARE PERIODS easily with SAMEPERIODLASTYEAR DAX Function // DAX Basics

Get Demo Files here

In this video were going to go through how to use the SAMEPERIODLASTYEAR DAX function to compare against last year periods really easily

Link to docs

-

🚩 Get Demo Files here

👍 Become a Patreon to support the channel and get free perks!

🛍 Get exclusive templates built using best practices here

❤ Other ways to support

GET IN TOUCH

🌍 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 YouTube.

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

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 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 #DataAnalytics #BusinessIntelligence

[andaregala]

Thanks, Fernan cleary explained.
Can you please do a presentation when target varies each year. Like sales target CY is 1.2% of total sale last last yr. And LY sales target was 1.1% of PY total sales. Can you please share PBi for such report. Thanks.

[RehanShaikh-iphh]

I have few questions but before that I will test and then give you comments

Hi, how are you? I love your videos... Btw I did the same thing for the "IF" part, but my table can't display the visual... I am still wondering about what could it be? Do you have any tips on that? Thx again, Aline.

[MsGargswati]

Hi How are you?

I want you to do a video on current year past 3month, 6month, 12 months and same for last Year and a delta change for both the values.

[damianusdeni]

thank you for your video Fernan.
However, I am still finding problem when the date slicer is added to the dashboard.
I still encounter blank last year data if I filter on this year (or other specific time).
How do you handle to visualize the last year sales when the date filter select only specific year?

Thank you.

[jeffreyhill]

How do you filter out fields which have blank previous year data without impacting the previous year data you should have in the report?

[TalhaAhmed..]

I have been trying this SAMEPERIODLASTYEAR but Matrix visual is not showing any result, it is just showing total at the bottom of the column., that's it. Can you help me please? Plus in some cases it was only showing result in month wise data, not in year wise data.