Muchas gracias! Un consulta, si quiero comparar por semanas, como hago?
@NestorAdrianzen18 сағат бұрын
Puedes usar DAY como el intervalo y -7 como el número de intervalos.
@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.
@manuelserna13693 күн бұрын
Muchas gracias por esta master class mi estimado ,saludos desde Panamá
@NestorAdrianzen3 күн бұрын
Gracias por revisar el contenido, Manuel!
@shoaibrehman99883 күн бұрын
Hi, i have a question, In Bravo calendar, the week number number column is present??
@NestorAdrianzen2 күн бұрын
Yes, it should be there. You need to unhide it. Select Table View > Select Date table > Unhide Day of Week Number
@xeeshanahmad87574 күн бұрын
Fabulous 👍
@NestorAdrianzen3 күн бұрын
Glad to hear that. Cheers!
@PCDrCaps4 күн бұрын
Espectacular Nestor, saludo desde México
@NestorAdrianzen4 күн бұрын
Excelente. Saludos 👍
@hadialavi24764 күн бұрын
Fantastic
@NestorAdrianzen4 күн бұрын
Glad to hear that. Cheers!
@xeeshanahmad87575 күн бұрын
Up to the mark, Bravo 💪👌👍
@NestorAdrianzen5 күн бұрын
Cheers!
@NestorAdrianzen5 күн бұрын
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 👇
@srinidhistiwari85077 күн бұрын
How can we use NETWORKDAYS formula for Averagex and sumx and working hour should count only with in UK time of 8Am - 5Pm
@srinidhistiwari85077 күн бұрын
Please can you help me on this?
@davidlopezblog42929 күн бұрын
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?
@NestorAdrianzen4 күн бұрын
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
@giovanyediazsalcedo97029 күн бұрын
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
@NestorAdrianzen4 күн бұрын
Giovany, Gracias por revisar el contenido. Puedes enviarme tu pregunta con detalles a [email protected]? Lo reviso y te comparto mi retroalimentación. Saludos
@xeeshanahmad875710 күн бұрын
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?
@xeeshanahmad875711 күн бұрын
Loud and Clear 👍. Valuable Tutorial.
@NestorAdrianzen10 күн бұрын
Glad it was helpful!
@xeeshanahmad875713 күн бұрын
Superb😁
@NestorAdrianzen13 күн бұрын
Glad to hear that!
@xeeshanahmad875713 күн бұрын
👌👍
@NestorAdrianzen13 күн бұрын
Cheers!
@ciroadolfo0115 күн бұрын
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
@NestorAdrianzen15 күн бұрын
Excelente, Adolfo. Saludos👍
@alexrosen876215 күн бұрын
Amazing tutorial. The best one so far 👌🙏👌
@NestorAdrianzen15 күн бұрын
Happy to hear that!
@pablovallejos217216 күн бұрын
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". 😅
@NestorAdrianzen4 күн бұрын
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
@mrbartuss118 күн бұрын
Could you please share the file so we could follow along?
@NestorAdrianzen18 күн бұрын
Here you go: drive.google.com/drive/folders/1P0lZZ0K5TtId1KZmsr7t1x6TSUFMg-xO
@mrbartuss118 күн бұрын
@@NestorAdrianzen Thank you!
@xeeshanahmad875718 күн бұрын
Super Amazing show, bro.
@NestorAdrianzen18 күн бұрын
Cheers!
@irfanabbassi920218 күн бұрын
Marco the Dax Legend
@NestorAdrianzen18 күн бұрын
You bet!
@NestorAdrianzen19 күн бұрын
How often do you use Bravo or DAX Studio to optimize your Power BI reports? Leave your comments below👇
@xeeshanahmad875719 күн бұрын
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.
@NestorAdrianzen18 күн бұрын
Glad to hear that. Cheers!
@xeeshanahmad875720 күн бұрын
Superb 👌
@NestorAdrianzen18 күн бұрын
Thank you! Cheers!
@cristiancontreras35221 күн бұрын
Excelente video, todo muy gradual como debe ser
@NestorAdrianzen21 күн бұрын
Excelente. Saludos 👍
@user-dw3wr9qj5f21 күн бұрын
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
@NestorAdrianzen21 күн бұрын
For YoY Growth % calculations, please reference this tutorial. kzbin.info/www/bejne/bKetenSAg7mXfZIsi=6KZRETviEsVG-mS5 Cheres!
@santiagobardelli567523 күн бұрын
me suscribi, sos un grande!
@NestorAdrianzen23 күн бұрын
Excelente. Saludos!
@xeeshanahmad875723 күн бұрын
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.
@NestorAdrianzen23 күн бұрын
Glad it helped!
@xeeshanahmad875723 күн бұрын
Excellent tutorial, Nestor! Your guidance made complex topics easy to understand.
@NestorAdrianzen23 күн бұрын
Glad to hear that!
@rodrigohernandez553724 күн бұрын
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!!
@NestorAdrianzen21 күн бұрын
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
@renatoravenna116625 күн бұрын
Thank you!
@NestorAdrianzen24 күн бұрын
Cheers!
@xeeshanahmad875726 күн бұрын
BRAVO, Highly recommended Feature . 👍
@NestorAdrianzen25 күн бұрын
Great!
@xeeshanahmad875726 күн бұрын
Brilliantly explained, Filter . Clears my Logic about filter and Nested Filters. Thanks
@NestorAdrianzen25 күн бұрын
Excellent!
@NestorAdrianzen26 күн бұрын
How often do you use Bravo for Power BI? Let me know by leaving a comment belwo👇
@rainbow43326 күн бұрын
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.
@NestorAdrianzen26 күн бұрын
Yes, I’m planning on doing a Power BI workshop for intermediate users. Stay tuned!
@xeeshanahmad875727 күн бұрын
👏👍
@NestorAdrianzen26 күн бұрын
👍
@xeeshanahmad875727 күн бұрын
very informative for the beginners thank you Nestor👌
@NestorAdrianzen26 күн бұрын
Glad to hear that!
@annaboinaanil127928 күн бұрын
Hi nestor , if you possible pl explain, how to total net average hours, minutes, and second with dax in power bi
@NestorAdrianzen21 күн бұрын
Instead of SUMX, please use AVERAGEX. That should give you averages instead.
@annaboinaanil12796 күн бұрын
Tried but didn't come, but will come 13:11:12
@flaviovalenciarodrigueznun652228 күн бұрын
Cómo hago para eliminar la columna que no quiero pero desde la barra de formula en query?
@NestorAdrianzen21 күн бұрын
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.
@flaviovalenciarodrigueznun652221 күн бұрын
@@NestorAdrianzen ok lo intentare, con ello se agrega un paso adicional o no?
@NestorAdrianzen21 күн бұрын
@@flaviovalenciarodrigueznun6522 correcto
@xeeshanahmad875729 күн бұрын
Smartly Explained and swiftly understood 👍
@NestorAdrianzen29 күн бұрын
Glad to hear that. Cheers!
@xeeshanahmad875729 күн бұрын
kzbin.infoUgkxHT_TmrU05rHKOa9WvGOBCs4PGMDFpuCe
@xeeshanahmad875729 күн бұрын
Done with Perfection , Thank you.👍
@NestorAdrianzen29 күн бұрын
Glad to hear it was helpful. Cheers!
@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Ай бұрын
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Ай бұрын
What's something new you learned in this Power BI workshop? Please share it below 👇
@xeeshanahmad8757Ай бұрын
Hmmmmmm, Yummmmmy
@NestorAdrianzenАй бұрын
Cheers!
@xeeshanahmad8757Ай бұрын
Just WoW
@NestorAdrianzenАй бұрын
👍
@NestorAdrianzenАй бұрын
👍
@xeeshanahmad8757Ай бұрын
Another beautiful video, Up to mark.👍
@NestorAdrianzenАй бұрын
Glad you found the content helpful!
@xeeshanahmad8757Ай бұрын
Yesterday i tried dashboards with Canva and now FIGMA. Quit surprising / Mesmerizing. Thanks for sharing