Тёмный

Power BI Year-Over-Year Growth % Calculations [DAX] 

Nestor Adrianzen
Подписаться 22 тыс.
Просмотров 102 тыс.
50% 1

Power BI Year-Over-Year Growth % Calculations [DAX]/
In this video, we will learn about year-over-year (YOY) growth calculations in Power BI, and we will use DAX functions to achieve this goal.
_______________
Highly recommended Power BI books: (Affiliate Links)
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
_______________
Relevant PBI Topics
- DAX Basics in Power BI Desktop: • DAX Basics in Power BI...
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
____________
[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.
You can navigate through the content below:
0:19 Content
1:03 What are YOY growth calculations
2:02 Requirements to find YOY growth calculations
3:35 Practical case
If you like the content, feel free to buy me a cup of coffee 😀👇www.paypal.me/vizxlization
Content Link: drive.google.com/file/d/1r9Al...
How to Compare Time Periods in Power BI: • How to Compare Time Pe...
Variables Explained: • How to Use VARIABLES i...
Please follow us on:
Web: www.vizxlization.com/
LinkedIn: / vizxlization
Facebook: / vizxlization
Instagram: / nestoradrianzen
Leave your comments and questions below!
If you found this helpful, don't forget to subscribe!
Thanks so much!
#vizxlization #YOY #DAX #PowerBI

Опубликовано:

 

19 июн 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 144   
@shelpng
@shelpng 3 года назад
I've tried SO many % change formulas and this was the only one that worked! Ty!
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Glad it helped, Shelly! keep up the good work.
@ojoaldatoDO
@ojoaldatoDO 3 года назад
Me has salvado la vida! Tenía ya una semana buscando una solución viable.
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Excelente, Andrés! Sigue adelante con ese empeño!
@ednareyes937
@ednareyes937 2 года назад
Thank you so much, I found this very clear and helpful. Was able to apply it right away!
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Wonderful! Keep up the great work, Edna!
@gjones86
@gjones86 3 года назад
This is brilliant and well explained - thank you!!
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Glad it was helpful! Keep up the good work, Grant 👊
@oliveirasouzafabio
@oliveirasouzafabio 2 года назад
Great tutorial, thank you so much!
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Glad you found it helpful, Fábio. Keep up the good work!
@mona12393
@mona12393 10 месяцев назад
Thank you so much for teaching time intelligence and calculating YOY growth calculation
@NestorAdrianzen
@NestorAdrianzen 10 месяцев назад
Glad you found this tutorial helpful. Cheers 👍
@stephaniewilson537
@stephaniewilson537 3 года назад
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!
@NestorAdrianzen
@NestorAdrianzen 3 года назад
I appreciate that!
@derrickmakhoba5279
@derrickmakhoba5279 2 года назад
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.
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Glad to hear that! Keep up the great work, Derrick!
@lizravenwood5317
@lizravenwood5317 3 года назад
Thanks. This is exactly what I was looking for. Well, some term over some term anyway...
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Liz, Glad it was helpful!
@evangelinekiku7380
@evangelinekiku7380 3 года назад
Hello, Thanks very much for the great videos. They are very helpful to me, given the fact that I am new to Power Bi.
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Excellent! Keep up the great work, Evangeline!
@63073savage
@63073savage 3 года назад
Muy bien hecho Nestor, muchisimas gracias!
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Excelente. Gracias por revisar el contenido, 63073savage.
@beyondtriggered4145
@beyondtriggered4145 2 года назад
Loved this. Thank you!
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Glad you enjoyed it!👍
@warunat
@warunat 2 года назад
Awesome ,explained - thank you
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Glad it was helpful!
@gauravrajpal3101
@gauravrajpal3101 2 года назад
It was an amazing tutorial to calculate the YOY 👍
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Glad you found the content helpful, Gaurav!
@happyheart9431
@happyheart9431 Год назад
Million thanks
@NestorAdrianzen
@NestorAdrianzen Год назад
Glad to hear that. Cheers!
@kaungmyatkyaw2986
@kaungmyatkyaw2986 2 года назад
Thanks a lot Nestor.
@NestorAdrianzen
@NestorAdrianzen 2 года назад
You bet! Thanks for stopping by, Kaung!
@talibali1988
@talibali1988 10 месяцев назад
Very informative. THANKS and keep it up
@NestorAdrianzen
@NestorAdrianzen 10 месяцев назад
Glad to hear that 👍
@rakeshmahakud110
@rakeshmahakud110 2 года назад
Very helpful
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Thanks for your support, Rakesh!
@raushankumarpandey897
@raushankumarpandey897 2 года назад
Very informative
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Thanks for your support, Raushan!
@irfanabbassi9202
@irfanabbassi9202 2 года назад
Beautiful explaination 😊
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Glad you found the content helpful. Cheers!
@user-du8zt6rz2o
@user-du8zt6rz2o 10 месяцев назад
Thank you for this. It helped me where I had been stuck. what about calculating MoM.
@NestorAdrianzen
@NestorAdrianzen 10 месяцев назад
Thanks for stopping by. For MoM, you just need to change the interval to MONTH. See example below: DATEADD( Dates[Date], -1, MONTH)
@raushanpandey4553
@raushanpandey4553 2 года назад
Nice explanation..
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Thanks for stopping by, Raushan!
@mohdmuzammil3059
@mohdmuzammil3059 4 года назад
Found very useful thank you
@NestorAdrianzen
@NestorAdrianzen 4 года назад
Glad you found this tutorial helpful, Mohd. Keep up the good work!
@mohdmuzammil3059
@mohdmuzammil3059 4 года назад
@@NestorAdrianzen kindly need your help with a RLS detailed on basic & Dyanamic security levels tutorials your respond will highly. appreciated
@NestorAdrianzen
@NestorAdrianzen 4 года назад
@@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!
@abdullah900iq
@abdullah900iq Год назад
thx
@NestorAdrianzen
@NestorAdrianzen Год назад
Thanks for stopping by. Cheers!
@NestorAdrianzen
@NestorAdrianzen 4 года назад
Please find the content link here below. Cheers! drive.google.com/file/d/1r9Ale74LOffKZld26MtPGEW46ZwurIql/view?usp=sharing
@pedrocson
@pedrocson 3 года назад
Thanks for the video! Can you also show how to create a DAX function for MOY growth?
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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.
@teresaray8303
@teresaray8303 3 года назад
​ @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.
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!
@hassantariq7250
@hassantariq7250 Год назад
Great Content My Friend !
@NestorAdrianzen
@NestorAdrianzen Год назад
Thanks for your feedback, Hassan Tariq!
@mmae007
@mmae007 Год назад
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?
@NestorAdrianzen
@NestorAdrianzen Год назад
There might be many reasons. Double check that the data type for the whole column is a numeric type.
@martinstasiuk2524
@martinstasiuk2524 3 года назад
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?
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!
@muratsahinel7302
@muratsahinel7302 2 года назад
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.
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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.
@king_tross
@king_tross Год назад
Thanks, this was really helpful. Is there any difference between using the 'PYPremium' variable or the 'PY Premium' measure in the YoY % Growth formula?
@NestorAdrianzen
@NestorAdrianzen Год назад
@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!
@GaGa-yx8to
@GaGa-yx8to Год назад
Thanks for the great tutorial! Where can I find the Calendar Table video?
@NestorAdrianzen
@NestorAdrianzen Год назад
Here you go! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IU_2rkTFrLY.html
@emirtahiri1949
@emirtahiri1949 2 года назад
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?
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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!
@emirtahiri1949
@emirtahiri1949 2 года назад
@@NestorAdrianzen thank you so much Nestor! Your content is so helpful! Much appreciated.
@shubhamraut8700
@shubhamraut8700 Год назад
@@NestorAdrianzen Even this helped me. Thanks, a lot for the wonderful content!
@pillajanardhankumar7369
@pillajanardhankumar7369 2 года назад
Hello ! Nestor, I have a question for you, how do you calculate YOY growth with financial year/ calender !
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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
@michellecleary4362
@michellecleary4362 Год назад
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?
@NestorAdrianzen
@NestorAdrianzen Год назад
Michellecleary4362, Yeah. You can do that. Make sure to use the CALCULATE function to modify the filter context (for year and product).
@hangoctuan824
@hangoctuan824 2 года назад
It's so Interesting! But can you help me in the case 6 Month 2021 over 6 month 2020? (compare the same period)
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Hà Ngọc Tuấn, Thanks for stopping by. Have you tried using the following syntax? DATEADD(Calendar[date], -6, MONTH))
@pnaveen143
@pnaveen143 2 года назад
Thank you soo much.. Please help data shown in table.. totals are shown
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Thanks for stopping by, Relax Daily!
@Griffindor21
@Griffindor21 Год назад
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?
@NestorAdrianzen
@NestorAdrianzen Год назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iR0s01axEgE.html
@sravankumar1767
@sravankumar1767 3 года назад
Awesome , I have one doubt what is the use of bookmarks &when should we use, what is page navigation ,uses
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!
@sravankumar1767
@sravankumar1767 3 года назад
@@NestorAdrianzen Thank you very much for share the valuable information
@Johanapieters
@Johanapieters Год назад
HI Nestor, I have a question why when I Add the date to ther table the information (measurements) despair from my table?
@NestorAdrianzen
@NestorAdrianzen Год назад
🤔 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!
@Johanapieters
@Johanapieters Год назад
@@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.
@sravankumar1767
@sravankumar1767 3 года назад
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..
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Sravan, Thanks for checking the content! For Relationships in Power BI, you might want to check the following tutorial out. Cheers! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4zmSzDeiYt4.html
@sravankumar1767
@sravankumar1767 3 года назад
@@NestorAdrianzen k
@sharmaakarsh
@sharmaakarsh 2 года назад
Hi Nestor , what if i also need a date drill down/hierarchy..will it work?
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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).
@johnabram4159
@johnabram4159 2 года назад
@ 11:30 since you already had PY Premium measure why did your create a variable for the same again?
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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!
@jeanfortes9239
@jeanfortes9239 3 года назад
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))
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!
@jeanfortes9239
@jeanfortes9239 3 года назад
@@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
@NestorAdrianzen 3 года назад
It should be “minus”: (Premium - PYPremium). I hope it helps!
@ginbui135
@ginbui135 2 года назад
@@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?
@Nickbless1
@Nickbless1 8 месяцев назад
Hello Nestor, please does the total premium contains all year Amounts?
@NestorAdrianzen
@NestorAdrianzen 8 месяцев назад
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!
@ChavaCar11
@ChavaCar11 3 года назад
how would you work Week over Week changes!!??
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!
@rohitsomany1
@rohitsomany1 3 года назад
Can we add ytd and mtd slicer with p.yr.
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!
@dataalive3281
@dataalive3281 2 года назад
How can I make the same análisis but chosing what 2 years compare? For example compare CY with 2019
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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!
@dataalive3281
@dataalive3281 2 года назад
@@NestorAdrianzen thank you! I haven't had the time to review my powerbi but I will try what you said thankss
@sinyolotzzz
@sinyolotzzz 2 года назад
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
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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.
@firdausismail3020
@firdausismail3020 10 месяцев назад
"Boom!"
@NestorAdrianzen
@NestorAdrianzen 10 месяцев назад
Thanks for stopping by! Boom 💥
@demris15
@demris15 Год назад
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
@babuv.k2541
@babuv.k2541 2 года назад
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
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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!
@zachariahabraham3356
@zachariahabraham3356 10 месяцев назад
can someone help .. i am not getting it when i put in the dates in the table ...
@NestorAdrianzen
@NestorAdrianzen 9 месяцев назад
Make sure that there is correct relationship between the calendar and fact tables.
@raju_dasari_030
@raju_dasari_030 3 года назад
I understand everything clearly only thing is y did u create date Tabe , what' s use of that ,we having already claims date
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IU_2rkTFrLY.html
@raju_dasari_030
@raju_dasari_030 3 года назад
@@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 ????
@juanignacioXI
@juanignacioXI 3 года назад
Hi Nestor, why u used PY again in a VAR if u had already created PY in a measure?
@NestorAdrianzen
@NestorAdrianzen 3 года назад
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!
@juanignacioXI
@juanignacioXI 3 года назад
@@NestorAdrianzen thanks Nestor for this awesome videos!
@pabeader1941
@pabeader1941 2 года назад
How would you do this for hour by hour?
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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
@pabeader1941
@pabeader1941 2 года назад
@@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!
@PM-ox2zu
@PM-ox2zu 3 года назад
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
@NestorAdrianzen
@NestorAdrianzen 3 года назад
P M, Thanks for stopping by. Could you please elaborate your question in more detail so I can guide you better?
@PM-ox2zu
@PM-ox2zu 3 года назад
@@NestorAdrianzen sure will send detailed requirement
@PM-ox2zu
@PM-ox2zu 3 года назад
@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
@harsh6639
@harsh6639 Год назад
hi could you pls help now its urgent ??
@carlosalvarezsolis7201
@carlosalvarezsolis7201 4 года назад
In spanish first please, speed speed, jeejje. Thanks a lot
@NestorAdrianzen
@NestorAdrianzen 4 года назад
Carlos, Thanks for following my tutorials. Yes, I'm working on it. I'll upload it next Saturday. Stay tuned.
@NestorAdrianzen
@NestorAdrianzen 4 года назад
Carlos, I've just posted this lesson in Spanish. Here is the link. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CJKJCM8DSLU.html
@luismagana3815
@luismagana3815 2 года назад
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
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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.
@sunnyn1343
@sunnyn1343 2 года назад
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
@NestorAdrianzen
@NestorAdrianzen 2 года назад
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!
@juansantamaria1982g
@juansantamaria1982g 3 года назад
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.
@NestorAdrianzen
@NestorAdrianzen 3 года назад
Issac Clarke, Thanks for stopping by. Have you tried the DAY interval instead? e.g., DATEADD (Dates[Date], -365, DAY). I hope it helps.
@rakeshmahakud110
@rakeshmahakud110 2 года назад
Very helpful
@NestorAdrianzen
@NestorAdrianzen 2 года назад
Glad to hear that. Keep it up, Rakesh!
Далее
It was like a real simulation👩🏻‍💻
00:15
Просмотров 1,9 млн
I Built a SECRET Soccer Field in My Room!
24:15
Просмотров 15 млн
How to Use VARIABLES in Dax Formulas in Power BI
17:13
How to Do a YTD Calculation in Power BI
3:24
Просмотров 6 тыс.
How to Use the CALCULATE Function in Power BI
19:31
Просмотров 58 тыс.
How to Calculate Year over Year Growth % in Power BI
6:53
It was like a real simulation👩🏻‍💻
00:15
Просмотров 1,9 млн