How to compare Last Year Last Month Sales Vs Current Year Sales Dynamically?

Join this channel to get access to perks:
/ @biconsultingpro
How to compare Last Year Last Month Sales Vs Current Year Sales Dynamically?
In this video, you'll learn how to compare LYLM Sales to CY Sales by selecting month dynamically.
Download .pbix file from here: biconsultingpr...
*****************Free Video Tutorials*************
* PL-300 Sample Questions Answers: onedrive.live....
* DP-203 Complete Tutorial - • DP-203: Data Engineeri...
* Power BI Tutorial for Beginners: • How to get started wit... ​
* Power BI Interview Questions: • Power BI Interview Que...
* Power Query Tutorial: • What is Power Query? H...
* Free Power BI Admin Tutorial: • How to use Power BI ad...
* Free Azure Data Factory Tutorial: • Azure Data Factory | A...
* Free Azure Databricks Tutorial: • Data Engineering with ...
* Free Power BI Synapse Analytics Tutorial: • Microsoft Azure Synaps...
* Data Modeling Tutorial: • What is Data Modeling?...
* Azure Analysis Services Tutorial: • What is Azure Analysis...
* Power BI Service Tutorial: • What is Power BI Servi...
* Free DAX tutorial: • Complete DAX Course - ...
* Field Parameters in Power BI: • May 2022 Power BI Upda...
* Optimize Power BI Performance: • How to optimise Power ...
* Send an e-mail alert to anyone: • How to send an Alert E...
*********************Important Links ***********************
* PL-300 Exam Tutorial: • PL- 300 Exam Tutorial
* How to make a career in Power BI? : • How to make a career i...
* Row-Level Security in Power BI Tutorial: • RLS in Power BI
* Power Query Tutorial for the beginners: • Power Query - Basic
* For the DP-203 Exam Tutorial: • DP-203: Data Engineeri...
* Power BI Admin Tutorials Series: • Power BI Admin Tutorial
* For more DAX Videos: • DAX Sundays
* For more Weekly Videos: • Power BI Weekly Videos
* Power BI in Hindi: • पावर बीआई हिंदी में
* Power BI Free Data Sources: • Where to get free data...
* Data Modelling in Power BI: • Data Modelling
* Power BI Audit Log: • How to get Power BI Au...
* Real-Time Data Analytics using Power BI: • Real-Time Data Analyti...
**********************************Most Popular Videos on Our Channel******************************
* How to pass DA-100/PL-300 Exam: • How to pass DA-100/PL-...
* Data Classification in Power BI: • Should you go for Powe... ​
* Sensitivity Labels in Power B: • What are Sensitivity L...
* Create and manage Sensitivity Labels in Power BI: • How to create and mana...
* What is Power BI Service? • What is Power BI Service? ​
* Power BI Data Model Analysis: • How to do data analysi...
* Filter Propagation Concept: • What is Filter Propaga...
* Dynamic Page Navigation with RLS Video: • How to Navigate Pages ...
* Incremental Refresh in Power BI: • What is Incremental Re...
* Create Date Table in Power BI: • 2 Ways to Create Simpl... ​
* Deployment Pipelines in Power BI: • What are the deploymen...
* XMLA EndPoint Connectivity in Power BI: • What is Dataset connec...
* RLS Vs OLS in Power BI: • What is Object-Level S...
* Power BI Data Gateway: • What is a Power BI Dat...
* Anomaly Detection in Power BI: • Anomaly Detection In P...
* Smart Narrative Visual in Power BI: • Video
* Free Datasources for Power BI: • Where to get free data...
* Free Data Sources to Practice Power BI: • Where to get free data...
************************************************************************
☎️ LET'S CONNECT!
************************************************************************
📺KZbin: / @biconsultingpro
🧰LinkedIn: / biconsultingpro
🐥 Twitter: / biconsultingpr1​
📱 Instagram: / biconsultingpro
➥ Facebook: / biconsultingpro
🧑‍💻 Website: www.biconsultingpro.com
#Daxsundays #powerbi #biconsultingpro

[@jennykua4029]

Thank you

[@MukeshSingh-cw5hr]

Hello Sir, Thanks for explaining previous year DAX. It worked for me . But if I try some additional filters on this visual for example: State or Product then the value is not changing. Please help

[@MukeshSingh-cw5hr]

Hello sir, please guide me on the above mentioned doubt please

[@prashantchauhan449]

Hi Sir, I want to compare Quarter to Quarter changes like (Jan 23 vs April 23) or (Jan 23 vs July 23) etc. and it shouldn't be a sum of first quarter (Jan + Feb + march). It should be a comparison of Jan 23 vs April or April 23 vs July 23 like that and on similar lines Annual (2022 Jan or April vs 2023 Jan or April comparison of sales data. Do we have any dynamic way to do this?

[@Sirigineedi_Navann]

Superb video brother 👏👏👏

[@BIConsultingPro]

Thank you so much 😀

[@MasweghoChris]

Nice video, can you please do this using Fiscal year that starts from July to June?

[@BIConsultingPro]

Fiscal year won't be an issue. You can simply get last month by following this: Calculate ( SUM(FactInternetSales[SalesAmount]), FILTER(DimDate, DimDate[Year] = Year(Today())-1 && DimDate[MonthName] = "July")) Rest, everything is going to be the same. I hope this will help you out.

[@MasweghoChris]

@@BIConsultingPro thank you I will give it a try

[@MasweghoChris]

@@BIConsultingPro This worked for a single measure, I have a set of measures to put on a matrix as snapshot view. Can you please look at this time intelligence dim i have built and tell me how i can adapt it to a financial year July to June? I have done some research and found the YFMYTD, Time Intelligence Periods = union( ADDCOLUMNS( SAMEPERIODLASTYEAR('Date'[Date]), ******This reads the calendar as normal not Fiscal Year***** "Period","0. Same Period LY" ), ADDCOLUMNS( DATESMTD('Date'[Date]), ******This reads the calendar as normal not Fiscal Year***** "Period","1. Period To Date" ), ADDCOLUMNS( PREVIOUSMONTH(DATESQTD('Date'[Date])), ******This reads the calendar as normal not Fiscal Year***** "Period","2. Prev Period" ), ADDCOLUMNS( DATESQTD('Date'[Date]),******This reads the calendar as normal not Fiscal Year***** "Period","3. Quarter To Date" ), ADDCOLUMNS( PREVIOUSQUARTER(DATESQTD('Date'[Date])), ******This reads the calendar as normal not Fiscal Year***** "Period","4. Prev Quarter" ), ADDCOLUMNS( DATESYTD('Date'[Date],"30/6"), ******* This works as I discovered that I have too define the year end******* "Period","5. Fiscal Year to Date" ) )

[@Nextwhatguru]

In case, if I had 2008 sales and would like to compare 2007 end to current year I.e 2008

[@BIConsultingPro]

You can try this but you need to verify the logic yourself. It's just an idea: Yearly Comparison = VAR Sales2007 = CALCULATE([Total Sales], FILTER(ALL('YourTable'), YEAR('YourTable'[Date]) = 2007)) VAR Sales2008 = CALCULATE([Total Sales], FILTER(ALL('YourTable'), YEAR('YourTable'[Date]) = 2008)) RETURN IF(ISBLANK(Sales2007) || ISBLANK(Sales2008), BLANK(), Sales2008 - Sales2007)