Excellent Nestor, very helpful. I wonder what the best way to display this data is? Normally I’d go with a combination bar and line chart but power BI doesn’t seem to like shrinking bar charts to fit a space and you end up with ugly scroll bars. Also, do you have any month-to-date or year-to-date tips? Great service as always!
@NestorAdrianzen
3 жыл бұрын
FEBEar, Thanks for taking a look at the content. I personally like line charts because it looks cleaner, but bar charts are also helpful. For YTD calculations, I'll suggest being familiar with DATESYTD. This second function is usually used with the CALCULATE function and it makes the whole formula more flexible. Cheers!
@FEBear1
3 жыл бұрын
@@NestorAdrianzen apologies, I meant comparing month to date with same period last month. Also, I understand about line charts but I always think they look a little bare on the page
@NestorAdrianzen
3 жыл бұрын
@@FEBear1 Have you tried these couple of measures? MTD := CALCULATE( SUM(Claim[Collected Premium]), DATESMTD(Dates[Date]) ) MTD LY := TOTALMTD( SUM(Claim[Collected Premium]), DATEADD(Dates[Date],-1,MONTH) ) I hope it helps!
@FEBear1
3 жыл бұрын
@@NestorAdrianzen oh, bless your heart Nestor! Thanks so much for taking the time to help me. I'll put them in and see how I get on. I truly appreciate it!
@thanomnoimoh9299
2 жыл бұрын
Thank you for your advice easy way for me to learn Power BI.
@NestorAdrianzen
2 жыл бұрын
Glad to hear that! Boom💥
@fcnc3024
3 жыл бұрын
This is great info. But what has me following this guy is his catch phrases "Boom and There you go!" I like it. I think I catch myself saying it now haha!
@NestorAdrianzen
3 жыл бұрын
Glad you found the content helpful, Frederick. Keep it up. Boom!!!
@patrickkinbonso1809
11 ай бұрын
Thanks Nestor. any idea please how to calculate 1 week rolling, 4 weeks rolling, and 12 weeks rolling NPS scores please on Power BI? Thanks
@NestorAdrianzen
11 ай бұрын
Hey Patrick, Thanks for stopping by. The analysis should be very similar to what I described in the tutorial. For a week, the number of intervals should be 7 days. For 4 weeks, the number of intervals should be 28 days. For 12 weeks, the number of intervals should be 84 days. See below an example for 4 weeks or 28 days. I hope that helps! DATESINPERIOD ( Dates[Date], MAX (Dates[Date]), - 28, DAY)
@matsrosenqvist
2 жыл бұрын
Thanks for this great tutorial. 👍
@NestorAdrianzen
2 жыл бұрын
Thanks for your support, Mats! Keep it 🆙
@bzflowerbee
3 жыл бұрын
Do we have YTD Average instead of rolling average in DAX? For : on the spreadsheet, A1 to A 10 I have value. So, the Excel formula will be =Average($A$1: $A10). Then, when I have the value in A11, the formula will be =Average($A$1: $A11). I hope you understand what I mean. Thanks.
@chakrabmonoj
2 жыл бұрын
Nestor - I thoroughly enjoy your videos. You step it out so well in every single lesson. Had question : can we use the Averagex function too, instead of dividing the rolling sum by the number of days? would not Averagex with a date filter achieve the same thing?
@NestorAdrianzen
2 жыл бұрын
Monoj, Thanks for your feedback. Yeah, you can also use the AVERAGEX function to find moving averages (check min 16:30). I provided you guys with a couple of options so you can adapt it based on your business requirements. Cheers!
@nikishanikki7933
2 жыл бұрын
Hi Nestor, pls help me - If I don't want to show all the years in the table (or graph) but I want the calculation of 12 month rolling avg remains same. If i am filtering out year from the table with help of slicer, the result of calculation is changing- My requirement is after filtering out unwanted year the calculation result remain same
@NestorAdrianzen
2 жыл бұрын
Nikisha, Thanks for stopping by. If you don't want to include a specific year in the rolling average calculations, you will want to add another filter to the CALCULATE function to exclude those years. By doing so, an external filter (slicer) won't change your results. See below as a reference a filter to exclude 2013: CALCULATE( [Total Premium], DateFilter, NOT(Dates[Year]) IN {2013} )
@sravankumar1767
3 жыл бұрын
how should we write 12 months rolling average using quick measure, and why should we count rows functions in this example can u explain it
@NestorAdrianzen
3 жыл бұрын
Sravan Kumar, The steps to create a 12-month rolling average, by using the quick measure feature, are very similar to what we performed in the case. For "Period", just select "Months." Also periods before should be 11 and periods after should be 1. Regarding your second question, keep in mind that an average is basically the sum of values divided by the number of those values (SUM of Values/# Of Values). So for the exercise, we needed to count the number of rows that the mentioned table had and we used that result as the denominator to find the moving average. I hope it helps!
@sravankumar1767
3 жыл бұрын
Hi Nestor, I have one doubt Is weighted Average Calculation and Rolling average is both are same or different. If it is not can u make a video on weighted average on monthly &weighted average on product how should we write a dax can u explain it
@NestorAdrianzen
3 жыл бұрын
Sravan, Thanks for your question. These are two different concepts. For weighted averages, some data points contribute more than others to find and average; whereas, moving averages are series of averages of different subsets of the full data set. I'll add weighted averages to my list as well.
@MuraliKrishna-cw1ge
3 жыл бұрын
How to implement silent authentication in power bi report server & How to refresh data set programmatically in power bi report server.
@NestorAdrianzen
3 жыл бұрын
Murali, Thanks for stopping by. I'm not familiar with silent authentication yet, so I'll do more research about it. Regarding how to refresh data automatically in Power BI Service, first you should install an On-premises data gateway (standard mode), and then you will have the option to set up an automatic refresh on your reports. I'll add to my list of tutorials this last one. Thanks.
@eltacvbo1
3 жыл бұрын
Ahora en español
@NestorAdrianzen
3 жыл бұрын
Angel, Gracias por revisar el contenido. Acabo de publicar la versión en español. Saludos! kzitem.info/news/bejne/2YBvnHunenWJg3o
@lamarimamen
3 жыл бұрын
Solo quiero recibir vídeos que esten en castellano
@NestorAdrianzen
3 жыл бұрын
Carmen, Gracias por revisar el contenido. Estaré publicando la versión en español el próximo sábado. Puedes revisar aquí en el link el canal en español en donde haré la publicación. Saludos. Link: kzitem.info/rock/o-_SN8RJtMrAOZj9SPbzrQ
Пікірлер: 28