This Year VS Last Year Time Comparisons & Differences In Power BI

[@alexxander7072]

Best Dashboard Tutorial ever, no wasting time, no hard word or anything, just pure knowledge. Keep it up bro you are the best

[@golnazqasemzadeh6233]

This was the only training video that actually helped me completing my BI Dashboards. Thank you.

[@EnterpriseDNA]

Hi @golnazqasemzadeh6233, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

[@DarkessMyOldFriend]

very useful, i have spent days on thinking the filter logic until i saw your tutorial.

[@DarkessMyOldFriend]

多謝！

[@MikeCummings-ki2nk]

Very informative. What if we want to compare 2 different years and let the user pick the years? So they could pick 2022 vs 2018 instead of being Year selected vs PY, which is helpful. Nice vid, quick, concise, no BSing.

[@Avinashkraj]

Excellent..you saved my time ..thank you

[@BrianReyes-r7n]

Hello, this is the solution I am looking for, but when I add the Last Year measures i create, I am getting Null values (only current year populates). Could this be because I am using a view in SQL as a source with all the fields needed, rather than making the joins within Power BI?

[@derekventura6581]

How would you do this if you wanted products in the rows (TVs, Computers, etc.) instead of the dates with the columns being CY and PY like you have it ? Trying to do a Price volume mix analysis

[@Tmv3v]

Hi, thank you very much for your tutorial. What if I am dealing with a measure which uses distinct count (on some id)? Problem emerges when a single id might span across several dates.

[@AntonioRodriguez-li9yj]

thanks for the video! very useful!

[@zafariqbalsyed6109]

Dear Sir its very informative video thanks and good luck

[@EnterpriseDNA]

Hi Zafar Iqbal Syed, glad you appreciated the video. We are so grateful to have had such positive feedback.

[@muhammadatiq-ur-rehman9788]

Thanks for your video , i have table with range of dates and i want to do Comparisons last 5 days vs current 5 days . is this possible ? like

[@EnterpriseDNA]

Hi muhammad, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. In this case, we don't know What're the table structures? How it looks like? In what scenario this will be implemented? And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful! You can subscribe to our KZbin channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@giri41]

If statement not working with sumx please help

[@satishkumardommeti8282]

Great exaample of comparison between two sets of data. I have a challenge to write a DAX measure for this variant of the problem. Let me say we are currently in Sept 2020 and my Filter selection is 2020 calendar year. I would like to compare CY Sales (Jan - Sep 2020) vs LY Sales (Jan - Sep 2019) and not Jan - Dec 2019. What is the best suited DAX function?

[@EnterpriseDNA]

Hello Satish Kumar Dommeti, thank you for posting your query onto our channel. Well as showcased into the video both the functions are useful i.e. "SAMEPERIODLASTYEAR()" as well "DATEADD()" function if you're trying to visualize the data "This Year V/s Last Year". If you've made the selection in the slicer as Year 2020 and have selected particular months than it will make the comparison between those months only and not the entire calendar year i.e. from Jan - Dec. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping this explanation clears the confusion and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/

[@CHQAQC]

What do I need to modify if I have multiple slicers (Time period and Product type) to dynamically change the previous year. The Total Sales changes accordingly but not the Total Sales PY when Product type is filtered

[@EnterpriseDNA]

Hello CHQAQC, Thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful and helpful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@robrayborn1349]

As always, very helpful. What would you do if you wanted to compare Work Days this year to same amount of Work Days (WeekDays - Holidays) from the previous year?

[@EnterpriseDNA]

Hello Rob Rayborn, thank you for posting your query onto our channel. Well it's quite an easy process. Firstly, you need to generate a date table. Once you generate the Date table and create the measures for "Total Sales" and "Total Sales LY". Just place the field "IsWorkingDay" from the Date table into the "FILTER PANE" and than only check the option of "TRUE" and uncheck the option of "FALSE" and now you'll have the analysis as per the workdays thereby excluding the weekend numbers. Below is the link provided for the reference from where you can copy the "M Code" and paste it in your Advanced Editor in order to generate the date table. We're also providing few of the links of the articles of our blogposts as well as links of the videos available onto our Enterprise DNA KZbin channel. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you'll find this useful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390/87 blog.enterprisedna.co/handling-weekday-vs-weekend-dates-in-power-bi-using-dax/ medium.com/@sam.mckay/compare-weekday-vs-weekend-sales-in-power-bi-using-dax-2d007f2d969 blog.enterprisedna.co/placing-workday-and-weekend-day-numbers-into-the-date-table-in-power-bi/ kzbin.info/www/bejne/aKbQl5eQetGperc forum.enterprisedna.co/

[@robrayborn1349]

@@EnterpriseDNA Thank you!

[@michaelabarbosa9718]

It worked perfectly on one of my data sets but when I repeated the same steps for another data set (in the same report) the table displays the Total Quantity and Quantity LY on separate lines, although they are in they should be on the same line. Basically my entire date column is doubled and Total Quantity is on every other line. My Quantity LY is on every line the Total Quantity is not on. The time intelligence calculations I try to complete are then inaccurate because of the issue mentioned above.

[@EnterpriseDNA]

Hello Michaela Barbosa, It is a little difficult to tell and provide the results without looking at the data structure, model and working of the PBIX file. So we encourage you to please write back to us to our Community Forum by providing a thorough description of the problem that you're having along with the PBIX file you are using as reference, as well as the mock-up results that you're trying to achieve. Our members and/or experts team will be able to assist you in a better and efficient manner. I have provided the link to our forum below: forum.enterprisedna.co/ Please make sure that you're subscribed to our KZbin channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference. Happy Learning!!! Thanks and Warm Regards, Enterprise DNA kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@MiguelGonzalez-op5hv]

What if my dates are not the same? I have a dataset using the "Week Start Date", since the week date doesn't start on the same date year over year, should i use a different date metric? Ex. YearWeek or Weeknumber? Thanks in advance!

[@EnterpriseDNA]

Hello Miguel Gonzalez, thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Still we're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA KZbin channel pertaining to this topic. Hoping you find this useful and meets your requirements that you've been looking for. Also make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA blog.enterprisedna.co/compare-time-periods-with-non-standard-date-tables-dax-and-power-bi/ blog.enterprisedna.co/calculating-month-on-month-change-custom-calendars-power-bi-and-dax/ forum.enterprisedna.co/t/non-standard-time-intelligence/10452 community.powerbi.com/t5/Community-Blog/Non-Standard-Date-Analysis-In-Power-BI-445-544-Calendars/ba-p/505316 kzbin.info/www/bejne/nZCWln-XgMyYe7M kzbin.info/www/bejne/l4Cno6J8aJyjp5I kzbin.info/www/bejne/oJTPiKF3bNV4rLs

[@kennethsmith9610]

Is a single date table sufficient or do you need a date table specific for each time specific measure?

[@EnterpriseDNA]

Hello Kenneth Smith, thank you for posting your query onto our channel. Well, single "ideal and compact" date table is absolutely more than sufficient in the data model to achieve the analysis. We don't have to create date table every time whenever we create new measures for the analysis. We're providing a link below where one of our expert had created different types of date tables to meet different types of business scenarios. You just need to copy the date table that's applicable in your scenario and paste in the Advanced Editor and generate the date table in your model. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this explanation useful and helpful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/c/M-Code-Showcase/38 forum.enterprisedna.co/

[@neha7714]

why im getting same values for both last yr n this yr?

[@EnterpriseDNA]

Hello @neha7714, The reason why you must be getting the same values is, on your reporting page, you might not have provided a date context either in the form of date slicer or any date related context within your visual. If you see the video carefully, we've provided a date context in the form of slicer on our reporting page. Provide a date related context on your reporting page and you'll start seeing the difference between the values i.e., for Last Year and This Year. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@lloydmadima4486]

Hi all, anyone to assist so I created quantity for last year but when I start toggling on the filter between years that entire column becomes blank, only when I do not have any year selected I get to see by scrolling down the table but soon as I use the year filter it becomes blank.

[@pedrotrills7490]

hey, I have the same problem here... How did u manage to solve it?

[@vitorgerberweiss6859]

you are amazing

[@EnterpriseDNA]

Hi Vitor, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

[@DarkessMyOldFriend]

❤

[@ilrefex91]

i love you man

[@EnterpriseDNA]

Hi , glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!