Master Power BI DAX Tips!
12:22
5 ай бұрын
QUIPU ANALYTICS is Born!
2:26
6 ай бұрын
DYNAMIC TITLES in Power BI Desktop
11:44
JULY 2023 Power BI Update
6:27
11 ай бұрын
Пікірлер
@andreaberdazaiz8580
@andreaberdazaiz8580 22 сағат бұрын
Muchas gracias! Un consulta, si quiero comparar por semanas, como hago?
@NestorAdrianzen
@NestorAdrianzen 18 сағат бұрын
Puedes usar DAY como el intervalo y -7 como el número de intervalos.
@fankitty929
@fankitty929 Күн бұрын
Thanks for this very informative video. Q - When there's a report that have multiple pages, is there a way to make the first page the main selection in the menu and page 2-4 all sub? Currently Page 1 is the main drop down + 1st subpage. Thanking you in advance.
@manuelserna1369
@manuelserna1369 3 күн бұрын
Muchas gracias por esta master class mi estimado ,saludos desde Panamá
@NestorAdrianzen
@NestorAdrianzen 3 күн бұрын
Gracias por revisar el contenido, Manuel!
@shoaibrehman9988
@shoaibrehman9988 3 күн бұрын
Hi, i have a question, In Bravo calendar, the week number number column is present??
@NestorAdrianzen
@NestorAdrianzen 2 күн бұрын
Yes, it should be there. You need to unhide it. Select Table View > Select Date table > Unhide Day of Week Number
@xeeshanahmad8757
@xeeshanahmad8757 4 күн бұрын
Fabulous 👍
@NestorAdrianzen
@NestorAdrianzen 3 күн бұрын
Glad to hear that. Cheers!
@PCDrCaps
@PCDrCaps 4 күн бұрын
Espectacular Nestor, saludo desde México
@NestorAdrianzen
@NestorAdrianzen 4 күн бұрын
Excelente. Saludos 👍
@hadialavi2476
@hadialavi2476 4 күн бұрын
Fantastic
@NestorAdrianzen
@NestorAdrianzen 4 күн бұрын
Glad to hear that. Cheers!
@xeeshanahmad8757
@xeeshanahmad8757 5 күн бұрын
Up to the mark, Bravo 💪👌👍
@NestorAdrianzen
@NestorAdrianzen 5 күн бұрын
Cheers!
@NestorAdrianzen
@NestorAdrianzen 5 күн бұрын
Have you been able to explore Bravo for Power BI yet? The results can be astonishing, especially in creating a calendar table and time intelligence calculations 👇
@srinidhistiwari8507
@srinidhistiwari8507 7 күн бұрын
How can we use NETWORKDAYS formula for Averagex and sumx and working hour should count only with in UK time of 8Am - 5Pm
@srinidhistiwari8507
@srinidhistiwari8507 7 күн бұрын
Please can you help me on this?
@davidlopezblog4292
@davidlopezblog4292 9 күн бұрын
Una consulta, si o si al momento de realizar la asignación del correo electrónico debe ser parte de la organización? hay alguna forma de realizarlo con correos para población externa?
@NestorAdrianzen
@NestorAdrianzen 4 күн бұрын
Funciona siempre y cuando los correos externos corporativos tengan licencia Power BI Pro al menos. Correos personales de gmail, hotmail, yahoo, etc. no los reconoce. Saludos
@giovanyediazsalcedo9702
@giovanyediazsalcedo9702 9 күн бұрын
Hola Ing. Nestor, Me gustaría tener una Asesoría Personalizada contigo, para tratar el tema de la interacción de horas hombre día con P6 y relacionarlo con Power Bi y Power Query. Saludos y quedo atento a tu Pronta respuesta
@NestorAdrianzen
@NestorAdrianzen 4 күн бұрын
Giovany, Gracias por revisar el contenido. Puedes enviarme tu pregunta con detalles a [email protected]? Lo reviso y te comparto mi retroalimentación. Saludos
@xeeshanahmad8757
@xeeshanahmad8757 10 күн бұрын
instead of using following MEASURE (1) YOY Premium Growth % = VAR PYPremium = CALCULATE([Total Premium],DATEADD(Dates[Date],-1,YEAR)) RETURN DIVIDE( ([Total Premium]-PYPremium),PYPremium) i used the following Measure and it works properly YOY_Premium Growth % = DIVIDE([Total_Premium]-[PY_Premium],[PY_Premium]) What is your suggestion?
@xeeshanahmad8757
@xeeshanahmad8757 11 күн бұрын
Loud and Clear 👍. Valuable Tutorial.
@NestorAdrianzen
@NestorAdrianzen 10 күн бұрын
Glad it was helpful!
@xeeshanahmad8757
@xeeshanahmad8757 13 күн бұрын
Superb😁
@NestorAdrianzen
@NestorAdrianzen 13 күн бұрын
Glad to hear that!
@xeeshanahmad8757
@xeeshanahmad8757 13 күн бұрын
👌👍
@NestorAdrianzen
@NestorAdrianzen 13 күн бұрын
Cheers!
@ciroadolfo01
@ciroadolfo01 15 күн бұрын
Saludos amigo Nestor. Lo revisé todo el contenido por un aproximado de 3 horas y gratamente sorprendido por la facilidad como explicas cada truco. Siguiendo tus pasos pudo avanzar los 10 a la vez y no me cabe menor duda esta Power Query, JUNTOS con el POWER PIVOT pueden darle la batalla al POWER BI. Al menos para pequeñas o quizás medianas empresas verdad ? Muchas gracias
@NestorAdrianzen
@NestorAdrianzen 15 күн бұрын
Excelente, Adolfo. Saludos👍
@alexrosen8762
@alexrosen8762 15 күн бұрын
Amazing tutorial. The best one so far 👌🙏👌
@NestorAdrianzen
@NestorAdrianzen 15 күн бұрын
Happy to hear that!
@pablovallejos2172
@pablovallejos2172 16 күн бұрын
Che no se si es un juego de palabras o que, pero YouTub3 traduce con subtitulos automáticos al nombre del canal cómo 'Bisexuales Station". 😅
@NestorAdrianzen
@NestorAdrianzen 4 күн бұрын
El traductor de KZbin no hace la traduccción correcta. Actualicé el nombre de mi compañía. Ahora lo puedes encontrar como Quipu Analytics (www.quipuanalytics.com). Saludos
@mrbartuss1
@mrbartuss1 18 күн бұрын
Could you please share the file so we could follow along?
@NestorAdrianzen
@NestorAdrianzen 18 күн бұрын
Here you go: drive.google.com/drive/folders/1P0lZZ0K5TtId1KZmsr7t1x6TSUFMg-xO
@mrbartuss1
@mrbartuss1 18 күн бұрын
@@NestorAdrianzen Thank you!
@xeeshanahmad8757
@xeeshanahmad8757 18 күн бұрын
Super Amazing show, bro.
@NestorAdrianzen
@NestorAdrianzen 18 күн бұрын
Cheers!
@irfanabbassi9202
@irfanabbassi9202 18 күн бұрын
Marco the Dax Legend
@NestorAdrianzen
@NestorAdrianzen 18 күн бұрын
You bet!
@NestorAdrianzen
@NestorAdrianzen 19 күн бұрын
How often do you use Bravo or DAX Studio to optimize your Power BI reports? Leave your comments below👇
@xeeshanahmad8757
@xeeshanahmad8757 19 күн бұрын
Thank you so much for creating such an insightful tutorial on how to insert a date table in Power BI! Your clear and concise explanation makes it so much easier to understand and implement. I really appreciate the effort you put into making this video.
@NestorAdrianzen
@NestorAdrianzen 18 күн бұрын
Glad to hear that. Cheers!
@xeeshanahmad8757
@xeeshanahmad8757 20 күн бұрын
Superb 👌
@NestorAdrianzen
@NestorAdrianzen 18 күн бұрын
Thank you! Cheers!
@cristiancontreras352
@cristiancontreras352 21 күн бұрын
Excelente video, todo muy gradual como debe ser
@NestorAdrianzen
@NestorAdrianzen 21 күн бұрын
Excelente. Saludos 👍
@user-dw3wr9qj5f
@user-dw3wr9qj5f 21 күн бұрын
Hi, can someone pls help... if we need to select a Year from slicer, then how to have YoY growth % changed as per the selected year in slicer? as we have multiple year ... pls guide what dax to use
@NestorAdrianzen
@NestorAdrianzen 21 күн бұрын
For YoY Growth % calculations, please reference this tutorial. kzbin.info/www/bejne/bKetenSAg7mXfZIsi=6KZRETviEsVG-mS5 Cheres!
@santiagobardelli5675
@santiagobardelli5675 23 күн бұрын
me suscribi, sos un grande!
@NestorAdrianzen
@NestorAdrianzen 23 күн бұрын
Excelente. Saludos!
@xeeshanahmad8757
@xeeshanahmad8757 23 күн бұрын
I just finished watching your video on using VARIABLES in DAX formulas in Power BI, and I wanted to take a moment to thank you for such a beautifully and simply explained tutorial. Your clear and concise explanations made it easy to understand the concept, logic, and practical uses of variables in DAX. Thank you once again for such an insightful and easy-to-follow video.
@NestorAdrianzen
@NestorAdrianzen 23 күн бұрын
Glad it helped!
@xeeshanahmad8757
@xeeshanahmad8757 23 күн бұрын
Excellent tutorial, Nestor! Your guidance made complex topics easy to understand.
@NestorAdrianzen
@NestorAdrianzen 23 күн бұрын
Glad to hear that!
@rodrigohernandez5537
@rodrigohernandez5537 24 күн бұрын
super great video! thanks! Just one question. Is there any way to use that same measure to visualize the data on a chart? For example I wanted to see the sum of that time but by month or by week. It does work on a matrix but not on a barchart or a line chart. When I add the measure to the axis nothing happens, it just stays blank. Thanks!!
@NestorAdrianzen
@NestorAdrianzen 21 күн бұрын
The measure works on table/matrix/card only because the result has a "text" format. I haven't figured out how to create a date-time measure that works on charts yet. This article might help. learn.microsoft.com/en-us/archive/technet-wiki/33644.powerbi-aggregating-durationtime-in-dax
@renatoravenna1166
@renatoravenna1166 25 күн бұрын
Thank you!
@NestorAdrianzen
@NestorAdrianzen 24 күн бұрын
Cheers!
@xeeshanahmad8757
@xeeshanahmad8757 26 күн бұрын
BRAVO, Highly recommended Feature . 👍
@NestorAdrianzen
@NestorAdrianzen 25 күн бұрын
Great!
@xeeshanahmad8757
@xeeshanahmad8757 26 күн бұрын
Brilliantly explained, Filter . Clears my Logic about filter and Nested Filters. Thanks
@NestorAdrianzen
@NestorAdrianzen 25 күн бұрын
Excellent!
@NestorAdrianzen
@NestorAdrianzen 26 күн бұрын
How often do you use Bravo for Power BI? Let me know by leaving a comment belwo👇
@rainbow433
@rainbow433 26 күн бұрын
It's a great experience with the dashboard. 😊 I also expect that some advanced visual experience on the dashboard. Please kindly make a video for it. 📹 Thanks a lot to Adrianzen. 🙏 Adrianzen.
@NestorAdrianzen
@NestorAdrianzen 26 күн бұрын
Yes, I’m planning on doing a Power BI workshop for intermediate users. Stay tuned!
@xeeshanahmad8757
@xeeshanahmad8757 27 күн бұрын
👏👍
@NestorAdrianzen
@NestorAdrianzen 26 күн бұрын
👍
@xeeshanahmad8757
@xeeshanahmad8757 27 күн бұрын
very informative for the beginners thank you Nestor👌
@NestorAdrianzen
@NestorAdrianzen 26 күн бұрын
Glad to hear that!
@annaboinaanil1279
@annaboinaanil1279 28 күн бұрын
Hi nestor , if you possible pl explain, how to total net average hours, minutes, and second with dax in power bi
@NestorAdrianzen
@NestorAdrianzen 21 күн бұрын
Instead of SUMX, please use AVERAGEX. That should give you averages instead.
@annaboinaanil1279
@annaboinaanil1279 6 күн бұрын
Tried but didn't come, but will come 13:11:12
@flaviovalenciarodrigueznun6522
@flaviovalenciarodrigueznun6522 28 күн бұрын
Cómo hago para eliminar la columna que no quiero pero desde la barra de formula en query?
@NestorAdrianzen
@NestorAdrianzen 21 күн бұрын
Si deseas usar fórmulas, puedes usar la función *Table.RemoveColumns* . For ejemplo = Table.RemoveColumns(#"Changed Type",{"Low", "High"}) Esta función elimina las columnas "Low" y "High" del paso anterior que se llama Changed Type. Power Query distingue entre mayúsculas y minúsculas.
@flaviovalenciarodrigueznun6522
@flaviovalenciarodrigueznun6522 21 күн бұрын
@@NestorAdrianzen ok lo intentare, con ello se agrega un paso adicional o no?
@NestorAdrianzen
@NestorAdrianzen 21 күн бұрын
@@flaviovalenciarodrigueznun6522 correcto
@xeeshanahmad8757
@xeeshanahmad8757 29 күн бұрын
Smartly Explained and swiftly understood 👍
@NestorAdrianzen
@NestorAdrianzen 29 күн бұрын
Glad to hear that. Cheers!
@xeeshanahmad8757
@xeeshanahmad8757 29 күн бұрын
kzbin.infoUgkxHT_TmrU05rHKOa9WvGOBCs4PGMDFpuCe
@xeeshanahmad8757
@xeeshanahmad8757 29 күн бұрын
Done with Perfection , Thank you.👍
@NestorAdrianzen
@NestorAdrianzen 29 күн бұрын
Glad to hear it was helpful. Cheers!
@xeeshanahmad8757
@xeeshanahmad8757 Ай бұрын
After Creating "Custom Period" Table 7D 15D 1M 6M YTD 1Y 3Y 5Y Max when you add "Order" Column , after that Sort by Column "Period" in Table view a Warning Message Appears "We cannot sort the "Period" column by "Order". There cant be more than one value in "Order" for the same value in "Period". Please choose a different column for sorting and updating the "Order" column. When you open Power Query editor and put numbers in "Order" Column, the column not shown in the table. Can I create that column in power query and put values.
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
Make sure that the "order" values are unique for each period. When you use "Enter data", you are actually using Power Query. Once you create the table, click on "Transform data" in the Home tab to get into the Power Query interface. You can make any changes in the Power Query interface.
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
What's something new you learned in this Power BI workshop? Please share it below 👇
@xeeshanahmad8757
@xeeshanahmad8757 Ай бұрын
Hmmmmmm, Yummmmmy
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
Cheers!
@xeeshanahmad8757
@xeeshanahmad8757 Ай бұрын
Just WoW
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
👍
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
👍
@xeeshanahmad8757
@xeeshanahmad8757 Ай бұрын
Another beautiful video, Up to mark.👍
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
Glad you found the content helpful!
@xeeshanahmad8757
@xeeshanahmad8757 Ай бұрын
Yesterday i tried dashboards with Canva and now FIGMA. Quit surprising / Mesmerizing. Thanks for sharing
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
Keep it up!
@xeeshanahmad8757
@xeeshanahmad8757 Ай бұрын
The way u say BOOM, pretty fabulous🤩
@NestorAdrianzen
@NestorAdrianzen Ай бұрын
Boom!
@xeeshanahmad8757
@xeeshanahmad8757 Ай бұрын
@@NestorAdrianzen 😁