Pilla, Thanks for stopping by. For fiscal years, you should add the last date of the fiscal year to your time intelligence calculation. For the example below, the fiscal year ends on 06/30 and starts on 07/01. Measure := CALCULATE( [Profit], DATESYTD(Dates[Date], "06/30") ) The post below will provide you with more guidance. Then you can follow he same steps described in my tutorial to find YoY calculations. www.linkedin.com/feed/update/urn:li:activity:6905875094380650496
@Nestor Adrianzen Thanks for your great videos and being so responsive! How would you account for the leap year? Right now I am looking at Week over Year changes and we are currently skipping week 5 to account for the extra week in January in 2020.
Frankly Terrible, What I know is that there is a historical bug handling leap years with calendars. So more complex DAX calculations are required to customize the calendar table. I definitely need to do more research on this. Thanks!
Thank you so much! This is very helpful. I followed the steps using my own dataset. However, the totals of the total premium and PY premium are different. Any idea why this might be?
Thanks a lot Nestor. It is really well structured presentation in deed. Just a question why did you prefer to use variable version of PY Premium? We have already created a measure in the same name Apparently , it gives the same result in DIVIDE () function too.
Thanks, this was really helpful. Is there any difference between using the 'PYPremium' variable or the 'PY Premium' measure in the YoY % Growth formula?
@king_tross, Thanks for stopping by. Yes, when you are creating your variables, you can directly reference the measures created at the beginning. There is no need to create the full expression again for each variable. I did it because I wanted you guys to practice. I hope that helps! Cheers!
Hi Nestor! I appreciate your content! Although one question.. Do we have to have a date table separately? Can't we simply refer to a date column in our data set?
Emir, Thanks for your question. If you have a date column in your dataset, you don't have to create a calendar table, but it's highly recommended to create one. By doing so, you will easily perform time intelligence calculations such as YTD, MTD, etc. If you don't want to use a calendar table, you need to reference the date column as follows: DATEADD (Table[DateColumn].[Date], -1, YEAR) I hope this helps!
in Relationships i had seen one option single filter direction, bi directional , cross filter direction what is the importance in power bi could you please explain it..
Sravan, Thanks for checking the content! For Relationships in Power BI, you might want to check the following tutorial out. Cheers! ua-cam.com/video/4zmSzDeiYt4/v-deo.html
Great tutorial! I am just confused at the graph, shouldnt the graph not have a common baseline (0%), should each year be starting from the highest figure of the previous year, more like a waterfall graph?
marvingorospe5354, Thanks for stopping by. There might be different ways to visualize your data. For this particular case, I used a clustered column chart. But I also see your point. For waterfall charts, you might want to check the following tutorial. ua-cam.com/video/iR0s01axEgE/v-deo.html
Thanks for following my tutorials. In order to make the time intelligence functions work, we need to compare "apples" to "apples" (month-month, quarter-quarter, year-year, day-day).Therefore, I'm afraid that there might not be a way to create such comparisons. At least I'm not aware of that trick yet. Sorry about that.
Great questions! I also need to create a couple of tutorials about Bookmarks and Page Navigation. Bookmarks are helpful if we want to tell stories with our visualizations because, by using these tools, we can record a specific part/state of a report (When a report has slicers and filters) and then tell the story. For Page Navigation, this tool helps to navigate from one page to another in a Power BI Report and we usually use buttons to call actions. I hope it helps. Cheers!
Great Tutorial! I just run into one problem that if I would like to display % grow horizontaly in Matrix table by months I got error message. Which formula should I use to display grow % horizontaly by month with year in each row?
Martin, Thanks for stopping by. It seems that this type of comparison works best if the "date" values are in the rows field. Also, if you want to compare month-over-month, you might want to use month as the Interval: DATEADD(Dates[Date],-1,MONTH)). Keep it up!
Nestor, Is there any way to do the same calculations without using a slicer on the products? Can I implement a filter within DAX to automatically calculate the percent change based on the years & specific products?
The “total premium” measure should give you the total premium amount based on the current context. If you add a filter for a specific year, the total premium amount will be just for that specific year. I hope that helps!
🤔 Interesting! There might be multiple reasons. First, make sure you are using a calendar table. Also, there should be an active relationship between the calendar table and the fact table in your model. Finally, make sure you have the latest Power BI Desktop version installed. I hope that helps. Cheers!
@@NestorAdrianzen HI Nelson, thank you for your swift reply. I don't have different source data but only one excel data with all information. I have the latest version installed.
It works, but just be careful when you read the data and tell the story. For example, you might be comparing QUARTERS from current year to QUARTERS from last year when you use the following expression as a filter: DATEADD (Dates[Date], -1 , YEAR).
Rohit Somani, Thanks for stopping by. For slicers, you might want to use column s (or calculated columns). The outcome of a measure is just a single value and won't work on a slicer. I hope this helps. Cheers!
Juan, Great observation. I wanted to use variables because the code is so much easy to read. For the first variable, I could have referenced the first measured (PY Premium) instead of writing the whole DAX code again. But I did it again just to get more familiar with the DATEADD function. I hope this answers your question. Cheers!
Hi, Nestor. Thank you for this video. I do have a question. I did follow all measurements, however, the PY and YOY appear only at the total count and not per year after adding the date column. May I know what would we the concern? "report" is my date column this is the measurement I used PY Employee Count = CALCULATE([Total Employee Count],DATEADD('ODOO HR'[REPORT],-1,YEAR))
Jean, thanks for stop stopping by. For the first component of the DATEADD function, you might want to use a date column from your calendar table. The calendar table should be connected to your ODOO HR. I hope it solves the issue. Cheers!
@@NestorAdrianzen thank you! It worked, I need to have a date table and not only use the date column on my data set. for the Growth %, May I know what formula did you use for the numerator? Did you use "*" or "+" between total premium and PYPremium?
@@NestorAdrianzen Hi Nestor, I am facing the same problem as Jean, PY and YOY appear only at the total count and not per year. I did use the Calendar table, as my measurement looked like this: PY Searches: CALCULATE([Total Searches],DATEADD(DIM_Date[Date],-1,YEAR)) The format of DIM_Date[Date] looks like this: 24/04/2021 00:00:00 and it has hierarchy including Year Quarter Month Day. Please can you help?
John, Thanks for stopping by. Yes, you could have also referenced the "PY Premium" measure in the "PYPremium" variable to get the same results. I'd encourage you to use variables because they improve code readability and performance. Cheers!
Raju Alex, Thanks for taking a look at the content. Good question. A date table is mandatory because Time Intelligence functions work well with the date column from the date table. A date table has a single date for every single row. You might want to check the following tutorial about the benefits of using a Date Table. Hope it helps!ua-cam.com/video/IU_2rkTFrLY/v-deo.html
@@NestorAdrianzen oh I got it ,and how to fetch yoy between particular year like data of sales between 2010-2020 I want only yoy for 2013-2017 ,which Dax should be used ????
Data Alive, Thanks for stopping by. You might want to create a measure with CALCULATE and one of its filters can be the year that you'd like to compare against to. I hope that helps!
Hi i have followed the steps on your video, however my PYSales amount does not show up.. it only shows blank.. the TotalSales is OK, they are showing without a problem
Sinyolotzzz, Thanks for stopping by. There might be multiple reasons. One that comes to mind is Data Type. Make sure that the data type is the same for all values in your your columns. e.g., Decimal type for numbers.
Chava_CR, Great question. You might want to use "DAY" as the interval and "-7" as number of intervals. e.g.,. DATEADD (Dates[Date], -7, DAY). I hope it helps. Cheers!
Hi Thanks for the video , can some one help me if my data only contains dates like this 2020Q1Jan , 2020Q1 Feb and i dont have exact date i need to do YOY QoQ etc, Can someone help me how to do that please
Babu, Thanks for stopping by. What you can do is to create a new column by using as a reference the column that you just described. For example, the new column would be like this: 01/01/2020, 02/01/2020, 03/01/2020. In order to do so, you can use the "Column from Examples" feature within Power Query in Power BI Desktop. Once you have the new column with the new format, you can easily create a Calendar table and start using time intelligence calculations such as YoY, QoQ, etc. I hope this helps!
Pabeader, Thanks for stopping by. Unfortunately and as of today, the DATEADD function is not build to handle hours. However, you can use a combination of CALCULATE, FILTER and TIMEVLAUE as a workaround. You might want to take a look at the following link for more details: community.powerbi.com/t5/Desktop/Compare-totals-with-last-hour/m-p/241109#M107007
@@NestorAdrianzen Thank you for the reply. I've been searching for months. I took a quick peek and it looks like you might have proven to be my savior!
Hi Could you help me on my requirement , 3Yr or 5 Yr or Growth Assumption YOY, all 3 will be one slicer as Radio button. Only one of these would be selected. If Growth Assumption YOY is selected , then a % for that would be entered in a text box please provide your email id will send this requirement to id Great help if you can provide the solution
@Nestor Adrianzen Thank you for the reply... I have crated one table with 3 years calculation, 5 Yrs, and Growth YOY and table used in slicer these shown as radio buttons when we select these selection in the slicer report will refresh as per the calculation now how to integrate with Tabular report where based on the selection Forecasted volumes should calculate refresh the values in the report -- when you select radio button in slicer Growth YOY is By default 3% will calculate in the forecasted volumes of fields, please can you tell how to achieve this, if any DAX query please provide me
Your explanation is very good but why don't you keep your screen in zoom mode not able to see the formula in clear vision... Hw we will learn... Your clarity is worst
Hey Sunny! Thanks for your feedback. I recorded this tutorial last year, but the new ones have a better resolution. Hope you found the content helpful!
L M, Gracias por revisar el contenido. Lo que podrías hacer es crear una columna nueva con el siguiente formato (ej., "01/01/2018", "01/01/2019"...). Luego le das el formato de fecha a la nueva columna. Unva vez realizado eso, se puede crear una tabla calendario para vincularla con la otra tabla. Finalmente, se debe aplicar las formulas DAX para encontrar YoY. Espero eso sirva de ayuda. Saludos.
![How to Compare Time Periods in Power BI [By using DATEADD]](http://i.ytimg.com/vi/32wDjtPBxQY/mqdefault.jpg)
![How to Compare Time Periods in Power BI [By using DATEADD]](/img/tr.png)
Please find the content link here below. Cheers! drive.google.com/file/d/1r9Ale74LOffKZld26MtPGEW46ZwurIql/view?usp=sharing
Thank you so much for teaching time intelligence and calculating YOY growth calculation
Glad you found this tutorial helpful. Cheers 👍
I've tried SO many % change formulas and this was the only one that worked! Ty!
Glad it helped, Shelly! keep up the good work.
Thank you for this. It helped me where I had been stuck.
what about calculating MoM.
Thanks for stopping by. For MoM, you just need to change the interval to MONTH.
See example below:
DATEADD( Dates[Date], -1, MONTH)
Hello ! Nestor, I have a question for you, how do you calculate YOY growth with financial year/ calender !
Pilla, Thanks for stopping by. For fiscal years, you should add the last date of the fiscal year to your time intelligence calculation. For the example below, the fiscal year ends on 06/30 and starts on 07/01.
Measure :=
CALCULATE(
[Profit],
DATESYTD(Dates[Date], "06/30")
)
The post below will provide you with more guidance. Then you can follow he same steps described in my tutorial to find YoY calculations. www.linkedin.com/feed/update/urn:li:activity:6905875094380650496
Me has salvado la vida! Tenía ya una semana buscando una solución viable.
Excelente, Andrés! Sigue adelante con ese empeño!
Thank you so much, I found this very clear and helpful. Was able to apply it right away!
Wonderful! Keep up the great work, Edna!
Thanks for the great tutorial! Where can I find the Calendar Table video?
Here you go! ua-cam.com/video/IU_2rkTFrLY/v-deo.html
Hello Nestor, thank you very much for the great videos. They are very helpful to me, given the fact that I am new to Power Bi.
Glad to hear that! Keep up the great work, Derrick!
@Nestor Adrianzen Thanks for your great videos and being so responsive! How would you account for the leap year? Right now I am looking at Week over Year changes and we are currently skipping week 5 to account for the extra week in January in 2020.
Frankly Terrible, What I know is that there is a historical bug handling leap years with calendars. So more complex DAX calculations are required to customize the calendar table. I definitely need to do more research on this. Thanks!
Great tutorial, thank you so much!
Glad you found it helpful, Fábio. Keep up the good work!
Thank you so much! This is very helpful. I followed the steps using my own dataset. However, the totals of the total premium and PY premium are different. Any idea why this might be?
There might be many reasons. Double check that the data type for the whole column is a numeric type.
Hello, Thanks very much for the great videos. They are very helpful to me, given the fact that I am new to Power Bi.
Excellent! Keep up the great work, Evangeline!
Thanks a lot Nestor. It is really well structured presentation in deed.
Just a question why did you prefer to use variable version of PY Premium? We have already created a measure in the same name Apparently , it gives the same result in DIVIDE () function too.
Murat, Thanks for your question. I prefer using variables because it's more readable and perform better. But to your point, we can also use measures.
Thanks, this was really helpful. Is there any difference between using the 'PYPremium' variable or the 'PY Premium' measure in the YoY % Growth formula?
@king_tross,
Thanks for stopping by. Yes, when you are creating your variables, you can directly reference the measures created at the beginning. There is no need to create the full expression again for each variable. I did it because I wanted you guys to practice.
I hope that helps!
Cheers!
I LOVE your video already and I am less than 5 minutes into the presentation! Subscribing to your channel to see more great videos. Thank you!
I appreciate that!
Hi Nestor! I appreciate your content! Although one question.. Do we have to have a date table separately? Can't we simply refer to a date column in our data set?
Emir, Thanks for your question. If you have a date column in your dataset, you don't have to create a calendar table, but it's highly recommended to create one. By doing so, you will easily perform time intelligence calculations such as YTD, MTD, etc.
If you don't want to use a calendar table, you need to reference the date column as follows:
DATEADD (Table[DateColumn].[Date], -1, YEAR)
I hope this helps!
@@NestorAdrianzen thank you so much Nestor! Your content is so helpful! Much appreciated.
@@NestorAdrianzen Even this helped me. Thanks, a lot for the wonderful content!
Thanks a lot Nestor.
You bet! Thanks for stopping by, Kaung!
in Relationships i had seen one option single filter direction, bi directional , cross filter direction what is the importance in power bi could you please explain it..
Sravan, Thanks for checking the content! For Relationships in Power BI, you might want to check the following tutorial out. Cheers! ua-cam.com/video/4zmSzDeiYt4/v-deo.html
@@NestorAdrianzen k
Great tutorial! I am just confused at the graph, shouldnt the graph not have a common baseline (0%), should each year be starting from the highest figure of the previous year, more like a waterfall graph?
marvingorospe5354, Thanks for stopping by. There might be different ways to visualize your data. For this particular case, I used a clustered column chart. But I also see your point. For waterfall charts, you might want to check the following tutorial. ua-cam.com/video/iR0s01axEgE/v-deo.html
Thanks for the video! Can you also show how to create a DAX function for MOY growth?
Thanks for following my tutorials. In order to make the time intelligence functions work, we need to compare "apples" to "apples" (month-month, quarter-quarter, year-year, day-day).Therefore, I'm afraid that there might not be a way to create such comparisons. At least I'm not aware of that trick yet. Sorry about that.
This is brilliant and well explained - thank you!!
Glad it was helpful! Keep up the good work, Grant 👊
Thanks. This is exactly what I was looking for. Well, some term over some term anyway...
Liz, Glad it was helpful!
It was an amazing tutorial to calculate the YOY 👍
Glad you found the content helpful, Gaurav!
Awesome , I have one doubt what is the use of bookmarks &when should we use, what is page navigation ,uses
Great questions! I also need to create a couple of tutorials about Bookmarks and Page Navigation. Bookmarks are helpful if we want to tell stories with our visualizations because, by using these tools, we can record a specific part/state of a report (When a report has slicers and filters) and then tell the story. For Page Navigation, this tool helps to navigate from one page to another in a Power BI Report and we usually use buttons to call actions. I hope it helps. Cheers!
@@NestorAdrianzen Thank you very much for share the valuable information
It's so Interesting! But can you help me in the case 6 Month 2021 over 6 month 2020? (compare the same period)
Hà Ngọc Tuấn, Thanks for stopping by.
Have you tried using the following syntax?
DATEADD(Calendar[date], -6, MONTH))
Great Tutorial! I just run into one problem that if I would like to display % grow horizontaly in Matrix table by months I got error message. Which formula should I use to display grow % horizontaly by month with year in each row?
Martin, Thanks for stopping by. It seems that this type of comparison works best if the "date" values are in the rows field. Also, if you want to compare month-over-month, you might want to use month as the Interval: DATEADD(Dates[Date],-1,MONTH)). Keep it up!
Very informative. THANKS and keep it up
Glad to hear that 👍
Million thanks
Glad to hear that. Cheers!
Nestor, Is there any way to do the same calculations without using a slicer on the products? Can I implement a filter within DAX to automatically calculate the percent change based on the years & specific products?
Michellecleary4362, Yeah. You can do that. Make sure to use the CALCULATE function to modify the filter context (for year and product).
Hello Nestor, please does the total premium contains all year Amounts?
The “total premium” measure should give you the total premium amount based on the current context. If you add a filter for a specific year, the total premium amount will be just for that specific year. I hope that helps!
Loved this. Thank you!
Glad you enjoyed it!👍
Awesome ,explained - thank you
Glad it was helpful!
Beautiful explaination 😊
Glad you found the content helpful. Cheers!
Very informative
Thanks for your support, Raushan!
Very helpful
Glad to hear that. Keep it up, Rakesh!
Thank you soo much.. Please help data shown in table.. totals are shown
Thanks for stopping by, Relax Daily!
Nice explanation..
Thanks for stopping by, Raushan!
Muy bien hecho Nestor, muchisimas gracias!
Excelente. Gracias por revisar el contenido, 63073savage.
HI Nestor, I have a question why when I Add the date to ther table the information (measurements) despair from my table?
🤔 Interesting! There might be multiple reasons. First, make sure you are using a calendar table. Also, there should be an active relationship between the calendar table and the fact table in your model. Finally, make sure you have the latest Power BI Desktop version installed. I hope that helps. Cheers!
@@NestorAdrianzen HI Nelson, thank you for your swift reply. I don't have different source data but only one excel data with all information. I have the latest version installed.
Hi Nestor , what if i also need a date drill down/hierarchy..will it work?
It works, but just be careful when you read the data and tell the story. For example, you might be comparing QUARTERS from current year to QUARTERS from last year when you use the following expression as a filter: DATEADD (Dates[Date], -1 , YEAR).
Can we add ytd and mtd slicer with p.yr.
Rohit Somani, Thanks for stopping by. For slicers, you might want to use column s (or calculated columns). The outcome of a measure is just a single value and won't work on a slicer. I hope this helps. Cheers!
Hi Nestor, why u used PY again in a VAR if u had already created PY in a measure?
Juan, Great observation. I wanted to use variables because the code is so much easy to read. For the first variable, I could have referenced the first measured (PY Premium) instead of writing the whole DAX code again. But I did it again just to get more familiar with the DATEADD function. I hope this answers your question. Cheers!
@@NestorAdrianzen thanks Nestor for this awesome videos!
Hi, Nestor. Thank you for this video. I do have a question. I did follow all measurements, however, the PY and YOY appear only at the total count and not per year after adding the date column. May I know what would we the concern? "report" is my date column
this is the measurement I used
PY Employee Count =
CALCULATE([Total Employee Count],DATEADD('ODOO HR'[REPORT],-1,YEAR))
Jean, thanks for stop stopping by. For the first component of the DATEADD function, you might want to use a date column from your calendar table. The calendar table should be connected to your ODOO HR. I hope it solves the issue. Cheers!
@@NestorAdrianzen thank you! It worked, I need to have a date table and not only use the date column on my data set. for the Growth %, May I know what formula did you use for the numerator? Did you use "*" or "+" between total premium and PYPremium?
It should be “minus”: (Premium - PYPremium). I hope it helps!
@@NestorAdrianzen Hi Nestor, I am facing the same problem as Jean, PY and YOY appear only at the total count and not per year. I did use the Calendar table, as my measurement looked like this:
PY Searches:
CALCULATE([Total Searches],DATEADD(DIM_Date[Date],-1,YEAR))
The format of DIM_Date[Date] looks like this: 24/04/2021 00:00:00 and it has hierarchy including Year Quarter Month Day.
Please can you help?
@ 11:30 since you already had PY Premium measure why did your create a variable for the same again?
John, Thanks for stopping by. Yes, you could have also referenced the "PY Premium" measure in the "PYPremium" variable to get the same results. I'd encourage you to use variables because they improve code readability and performance. Cheers!
Great Content My Friend !
Thanks for your feedback, Hassan Tariq!
I understand everything clearly only thing is y did u create date Tabe , what' s use of that ,we having already claims date
Raju Alex, Thanks for taking a look at the content. Good question. A date table is mandatory because Time Intelligence functions work well with the date column from the date table. A date table has a single date for every single row. You might want to check the following tutorial about the benefits of using a Date Table. Hope it helps!ua-cam.com/video/IU_2rkTFrLY/v-deo.html
@@NestorAdrianzen oh I got it ,and how to fetch yoy between particular year like data of sales between 2010-2020 I want only yoy for 2013-2017 ,which Dax should be used ????
thx
Thanks for stopping by. Cheers!
How can I make the same análisis but chosing what 2 years compare? For example compare CY with 2019
Data Alive, Thanks for stopping by. You might want to create a measure with CALCULATE and one of its filters can be the year that you'd like to compare against to.
I hope that helps!
@@NestorAdrianzen thank you! I haven't had the time to review my powerbi but I will try what you said thankss
Hi i have followed the steps on your video, however my PYSales amount does not show up.. it only shows blank.. the TotalSales is OK, they are showing without a problem
Sinyolotzzz,
Thanks for stopping by. There might be multiple reasons. One that comes to mind is Data Type. Make sure that the data type is the same for all values in your your columns. e.g., Decimal type for numbers.
Found very useful thank you
Glad you found this tutorial helpful, Mohd. Keep up the good work!
@@NestorAdrianzen kindly need your help with a RLS detailed on basic & Dyanamic security levels tutorials your respond will highly. appreciated
@@mohdmuzammil3059 Thanks for your suggestion. I'll add it to my to-do list. In the meantime, I hope you are enjoying the tutorials. Cheers!
how would you work Week over Week changes!!??
Chava_CR, Great question. You might want to use "DAY" as the interval and "-7" as number of intervals. e.g.,. DATEADD (Dates[Date], -7, DAY). I hope it helps. Cheers!
Hi Thanks for the video , can some one help me if my data only contains dates like this 2020Q1Jan , 2020Q1 Feb and i dont have exact date i need to do YOY QoQ etc, Can someone help me how to do that please
Babu,
Thanks for stopping by. What you can do is to create a new column by using as a reference the column that you just described. For example, the new column would be like this: 01/01/2020, 02/01/2020, 03/01/2020. In order to do so, you can use the "Column from Examples" feature within Power Query in Power BI Desktop. Once you have the new column with the new format, you can easily create a Calendar table and start using time intelligence calculations such as YoY, QoQ, etc.
I hope this helps!
How would you do this for hour by hour?
Pabeader, Thanks for stopping by. Unfortunately and as of today, the DATEADD function is not build to handle hours. However, you can use a combination of CALCULATE, FILTER and TIMEVLAUE as a workaround. You might want to take a look at the following link for more details: community.powerbi.com/t5/Desktop/Compare-totals-with-last-hour/m-p/241109#M107007
@@NestorAdrianzen Thank you for the reply. I've been searching for months. I took a quick peek and it looks like you might have proven to be my savior!
"Boom!"
Thanks for stopping by! Boom 💥
Just ignored that fact that you had a negative -100% in your visual and assumed it was being filtered out... I cant figured out how to remove that
can someone help .. i am not getting it when i put in the dates in the table ...
Make sure that there is correct relationship between the calendar and fact tables.
Hi Could you help me on my requirement , 3Yr or 5 Yr or Growth Assumption YOY, all 3 will be one slicer as Radio button. Only one of these would be selected.
If Growth Assumption YOY is selected , then a % for that would be entered in a text box
please provide your email id will send this requirement to id Great help if you can provide the solution
P M, Thanks for stopping by. Could you please elaborate your question in more detail so I can guide you better?
@@NestorAdrianzen sure will send detailed requirement
@Nestor Adrianzen Thank you for the reply... I have crated one table with 3 years calculation, 5 Yrs, and Growth YOY and table used in slicer these shown as radio buttons when we select these selection in the slicer report will refresh as per the calculation now how to integrate with Tabular report where based on the selection Forecasted volumes should calculate refresh the values in the report -- when you select radio button in slicer Growth YOY is By default 3% will calculate in the forecasted volumes of
fields, please can you tell how to achieve this, if any DAX query please provide me
In spanish first please, speed speed, jeejje. Thanks a lot
Carlos, Thanks for following my tutorials. Yes, I'm working on it. I'll upload it next Saturday. Stay tuned.
Carlos, I've just posted this lesson in Spanish. Here is the link. ua-cam.com/video/CJKJCM8DSLU/v-deo.html
hi could you pls help now its urgent ??
Your explanation is very good but why don't you keep your screen in zoom mode not able to see the formula in clear vision... Hw we will learn... Your clarity is worst
Hey Sunny! Thanks for your feedback. I recorded this tutorial last year, but the new ones have a better resolution. Hope you found the content helpful!
Hola, Esta Excelente, pero cuando solo tengo el año solamente, es decir no tengo un campo de fecha, como pudiera hacer el YoY??
Year Series Busi Cost Vol
2018 PS1 B1 $1 100
2018 PS2 B1 $2 300
2018 PS3 B1 $3 200
2019 PS1 B1 $2 200
2019 PS2 B1 $3 300
2019 PS3 B1 $1 100
2018 PS4 B2 $3 300
2018 PS5 B2 $2 100
2018 PS6 B2 $1 200
2019 PS4 B2 $2 200
2019 PS5 B2 $2 200
2019 PS6 B2 $3 100
L M, Gracias por revisar el contenido. Lo que podrías hacer es crear una columna nueva con el siguiente formato (ej., "01/01/2018", "01/01/2019"...). Luego le das el formato de fecha a la nueva columna. Unva vez realizado eso, se puede crear una tabla calendario para vincularla con la otra tabla. Finalmente, se debe aplicar las formulas DAX para encontrar YoY. Espero eso sirva de ayuda. Saludos.
How do you solve the leap year problem? When i try to use DATEADD to return the last year, it returns nothing when we are in february of a leap years.
Issac Clarke, Thanks for stopping by. Have you tried the DAY interval instead? e.g., DATEADD (Dates[Date], -365, DAY). I hope it helps.
Very helpful
Thanks for your support, Rakesh!