{"id":905,"date":"2026-04-14T19:56:42","date_gmt":"2026-04-15T00:56:42","guid":{"rendered":"https:\/\/cedipvirtual.com\/webpage\/?page_id=905"},"modified":"2026-04-14T19:56:42","modified_gmt":"2026-04-15T00:56:42","slug":"power-bi-2-funciones-query-y-dax","status":"publish","type":"page","link":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/","title":{"rendered":"Power BI 2: Funciones QUERY y DAX"},"content":{"rendered":"\n<br><div class=\"curso-container-premium\">\n    <header class=\"curso-header\">\n        <span class=\"badge-v\">ESPECIALIZACI\u00d3N AVANZADA<\/span>\n        <h1>Power BI 2: Funciones QUERY y DAX<\/h1>\n        <div class=\"imagen-central\">\n            <img decoding=\"async\" src=\"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/Analisis-de-Datos.png\" alt=\"An\u00e1lisis de Datos Avanzado Power BI\">\n        <\/div>\n    <\/header>\n\n    <div class=\"grid-contenido\">\n        <div class=\"info-principal\">\n            <p class=\"resumen\">\n                Consolida tus habilidades t\u00e9cnicas dominando a fondo el <strong>Lenguaje DAX<\/strong> y sus componentes avanzados. En este nivel, profundizamos en la iteraci\u00f3n de visualizaciones complejas y el modelado de datos de alto rendimiento para generar informes de inteligencia empresarial de nivel experto.\n            <\/p>\n\n            <div class=\"modulos-preview\">\n                <h3>Ejes Principales del Programa:<\/h3>\n                <div class=\"check-item\"><strong>DAX Profundo:<\/strong> Uso de funciones de iteraci\u00f3n y contextos de filtro complejos.<\/div>\n                <div class=\"check-item\"><strong>Optimizaci\u00f3n QUERY:<\/strong> T\u00e9cnicas avanzadas de transformaci\u00f3n y modelado de datos.<\/div>\n                <div class=\"check-item\"><strong>Visualizaci\u00f3n Din\u00e1mica:<\/strong> Creaci\u00f3n de informes interactivos con navegaci\u00f3n avanzada.<\/div>\n                <div class=\"check-item\"><strong>Business Intelligence:<\/strong> Aplicaci\u00f3n de l\u00f3gica de negocio para decisiones cr\u00edticas.<\/div>\n            <\/div>\n        <\/div>\n\n        <aside class=\"ficha-tecnica\">\n            <div class=\"ficha-card\">\n                <div class=\"precio-fake\">Capacitaci\u00f3n Certificada<\/div>\n                <ul class=\"detalles-lista\">\n                    <li><span>\ud83d\udccd<\/span> <strong>Modalidad:<\/strong> 100% Virtual (En Vivo)<\/li>\n                    <li><span>\u23f1\ufe0f<\/span> <strong>Duraci\u00f3n:<\/strong> 40 Horas Acad\u00e9micas<\/li>\n                    <li><span>\ud83d\udcdd<\/span> <strong>Estructura:<\/strong> 30h Clase \/ 10h Tareas<\/li>\n                    <li><span>\ud83c\udf93<\/span> <strong>Certificado:<\/strong> De Aprobaci\u00f3n<\/li>\n                <\/ul>\n                <a href=\"https:\/\/wa.me\/593984357883?text=%C2%A1Hola%21%20%F0%9F%91%8B%20Me%20interesa%20continuar%20mi%20formaci%C3%B3n%20en%20el%20curso%20avanzado%20*Power%20BI%202%3A%20Funciones%20QUERY%20y%20DAX*.%20%C2%BFPodr%C3%ADan%20ayudarme%20con%20horarios%20y%20costos%3F\" class=\"cta-whatsapp\" target=\"_blank\">\n                    CONSULTAR HORARIOS POR WHATSAPP\n                <\/a>\n                <p class=\"atencion-wa\">Atenci\u00f3n inmediata: <strong>+593 98 435 7883<\/strong><\/p>\n            <\/div>\n        <\/aside>\n    <\/div>\n<\/div>\n\n<style>\n\/* Estilos Generales *\/\n.curso-container-premium {\n    max-width: 1200px;\n    margin: 40px auto;\n    padding: 0 20px;\n    font-family: 'Segoe UI', Roboto, sans-serif;\n    color: #2d3436;\n}\n\n\/* Header e Imagen Centrada *\/\n.curso-header { text-align: center; margin-bottom: 50px; }\n.badge-v {\n    background: #004A31;\n    color: white;\n    padding: 6px 15px;\n    border-radius: 50px;\n    font-size: 0.8rem;\n    font-weight: 800;\n    letter-spacing: 1px;\n}\n.curso-header h1 {\n    font-size: 2.8rem;\n    font-weight: 900;\n    color: #004A31;\n    margin: 20px 0;\n}\n\n\/* CAMBIO DE MEDIDAS EN LA FOTO *\/\n.imagen-central {\n    width: 100%;\n    max-width: 500px; \/* Tama\u00f1o reducido para mayor elegancia *\/\n    margin: 25px auto; \/* Centrado perfecto *\/\n    border-radius: 15px;\n    overflow: hidden;\n    box-shadow: 0 15px 35px rgba(0,0,0,0.1);\n    border: 1px solid #eee;\n}\n.imagen-central img { \n    width: 100%; \n    height: auto; \n    display: block; \n}\n\n\/* Grid de Contenido *\/\n.grid-contenido {\n    display: grid;\n    grid-template-columns: 1.8fr 1.2fr;\n    gap: 40px;\n    align-items: start;\n}\n\n\/* Info Principal *\/\n.resumen { font-size: 1.2rem; line-height: 1.8; color: #636e72; margin-bottom: 30px; }\n.modulos-preview h3 { color: #004A31; margin-bottom: 20px; }\n.check-item {\n    padding: 12px 0;\n    font-size: 1.05rem;\n    border-bottom: 1px solid #f1f2f6;\n    display: flex;\n    align-items: center;\n}\n.check-item::before {\n    content: \"\u2714\ufe0f\";\n    margin-right: 15px;\n    color: #25d366;\n}\n\n\/* Ficha T\u00e9cnica *\/\n.ficha-card {\n    background: #ffffff;\n    padding: 30px;\n    border-radius: 25px;\n    border: 1px solid #f1f2f6;\n    box-shadow: 0 30px 60px rgba(0,0,0,0.08);\n}\n.precio-fake {\n    text-align: center;\n    font-weight: 900;\n    font-size: 1.2rem;\n    color: #004A31;\n    margin-bottom: 20px;\n    text-transform: uppercase;\n}\n.detalles-lista { list-style: none; padding: 0; margin-bottom: 30px; }\n.detalles-lista li {\n    padding: 15px 0;\n    border-bottom: 1px solid #f1f2f6;\n    display: flex;\n    gap: 15px;\n    font-size: 0.95rem;\n}\n.cta-whatsapp {\n    display: block;\n    background: #25d366;\n    color: white;\n    text-align: center;\n    padding: 18px;\n    border-radius: 12px;\n    text-decoration: none;\n    font-weight: 800;\n    transition: 0.3s;\n}\n.cta-whatsapp:hover { background: #1ebe57; transform: translateY(-3px); }\n.atencion-wa { text-align: center; font-size: 0.8rem; margin-top: 15px; color: #b2bec3; }\n\n\/* AJUSTES M\u00d3VIL *\/\n@media (max-width: 900px) {\n    .grid-contenido { grid-template-columns: 1fr; }\n    .curso-header h1 { font-size: 2rem; }\n    .ficha-tecnica { order: -1; } \n    .imagen-central { \n        max-width: 90%; \n        margin: 20px auto; \n    }\n}\n<\/style>\n\n\n\n<div class=\"wp-block-stackable-divider stk-block-divider stk-block stk-de09c22\" data-block-id=\"de09c22\"><hr class=\"stk-block-divider__hr\"\/><\/div>\n\n\n\n<div class=\"contenedor-admin-flexible\">\n    <div class=\"tarjeta-v\">\n        <h3>\ud83d\udccb Requisitos<\/h3>\n        <ul>\n            <li>Power BI nivel b\u00e1sico (indispensable).<\/li>\n            <li>Excel avanzado.<\/li>\n            <li>PC con 2GB RAM (4GB recomendado).<\/li>\n            <li>Aud\u00edfonos y conexi\u00f3n estable.<\/li>\n        <\/ul>\n    <\/div>\n\n    <div class=\"tarjeta-v\">\n        <h3>\ud83d\udc65 Dirigido a<\/h3>\n        <p>Profesionales y estudiantes de tercer nivel que manejen grandes vol\u00famenes de datos y busquen an\u00e1lisis avanzados.<\/p>\n    <\/div>\n\n    <div class=\"tarjeta-v verde-destacado\">\n        <h3>\ud83d\udcb0 Descuentos<\/h3>\n        <ul>\n            <li>10% Grupos (3+ personas).<\/li>\n            <li>10% Cliente frecuente.<\/li>\n            <li>50% Tercera edad \/ Discapacidad.<\/li>\n        <\/ul>\n    <\/div>\n\n    <div class=\"tarjeta-v\">\n        <h3>\ud83c\udf93 Certificaci\u00f3n<\/h3>\n        <p>Certificado oficial de aprobaci\u00f3n emitido al finalizar y aprobar el programa acad\u00e9mico.<\/p>\n    <\/div>\n<\/div>\n\n<style>\n\/* CONTENEDOR PRINCIPAL - LINEAL EN WEB *\/\n.contenedor-admin-flexible {\n    display: flex; \n    flex-wrap: nowrap; \n    gap: 20px; \n    max-width: 1200px;\n    margin: 30px auto;\n    font-family: 'Segoe UI', Roboto, sans-serif;\n    padding: 0 15px;\n}\n\n\/* ESTILO DE LAS TARJETAS *\/\n.tarjeta-v {\n    flex: 1; \n    background: #f8f9fa;\n    padding: 20px;\n    border-radius: 20px;\n    border-left: 6px solid #004A31;\n    box-shadow: 0 4px 15px rgba(0,0,0,0.03);\n    min-height: 180px;\n    transition: transform 0.3s ease;\n}\n\n.tarjeta-v:hover {\n    transform: translateY(-5px);\n}\n\n.verde-destacado {\n    background: #eef7f2;\n}\n\n.tarjeta-v h3 {\n    margin-top: 0;\n    font-size: 1.1rem;\n    color: #004A31;\n    font-weight: 800;\n    margin-bottom: 12px;\n}\n\n.tarjeta-v p, .tarjeta-v li {\n    font-size: 0.9rem;\n    line-height: 1.5;\n    color: #444;\n}\n\n.tarjeta-v ul {\n    margin: 0;\n    padding-left: 18px;\n}\n\n\/* --- M\u00d3VIL (Cambia a vertical) --- *\/\n@media (max-width: 900px) {\n    .contenedor-admin-flexible {\n        flex-direction: column; \n    }\n    \n    .tarjeta-v {\n        flex: none;\n        width: 100%; \n        box-sizing: border-box;\n        min-height: auto;\n    }\n}\n<\/style>\n\n\n\n<div class=\"wp-block-stackable-divider stk-block-divider stk-block stk-95c76ee\" data-block-id=\"95c76ee\"><hr class=\"stk-block-divider__hr\"\/><\/div>\n\n\n\n<div class=\"contenedor-temario-cedip\">\n    <h2 class=\"titulo-exclusivo\">Especializaci\u00f3n Avanzada: Power BI (QUERY &#038; DAX)<\/h2>\n    <p class=\"bajada-titulo\">30 Horas de Entrenamiento en Vivo + 10 Horas de Aplicaci\u00f3n Pr\u00e1ctica<\/p>\n    \n    <div class=\"grid-temario-cedip\">\n        <details class=\"modulo-v\">\n            <summary>\n                <div class=\"capa-titulo\">\n                    <span class=\"icono-v\">\ud83e\udde0<\/span>\n                    <span class=\"texto-v\">Fase 1: Arquitectura y L\u00f3gica DAX (2h)<\/span>\n                <\/div>\n            <\/summary>\n            <div class=\"bloque-contenido\">\n                <ul>\n                    <li><strong>Fundamentos Pro:<\/strong> Sintaxis avanzada y componentes del modelo de datos.<\/li>\n                    <li><strong>Contextos de Evaluaci\u00f3n:<\/strong> Dominio de Contexto de Filtro y Contexto de Fila.<\/li>\n                    <li><strong>Interacci\u00f3n Din\u00e1mica:<\/strong> L\u00f3gica de interacci\u00f3n de contextos en modelos complejos.<\/li>\n                <\/ul>\n            <\/div>\n        <\/details>\n\n        <details class=\"modulo-v\">\n            <summary>\n                <div class=\"capa-titulo\">\n                    <span class=\"icono-v\">\ud83d\udcca<\/span>\n                    <span class=\"texto-v\">Fase 2: Funciones Escalares y Tabulares (6h)<\/span>\n                <\/div>\n            <\/summary>\n            <div class=\"bloque-contenido\">\n                <ul>\n                    <li><strong>Agregaciones Pro:<\/strong> Uso avanzado de SUM, AVERAGE, MAX y DISTINCTCOUNT.<\/li>\n                    <li><strong>Conteo de Registros:<\/strong> Optimizaci\u00f3n con COUNTROWS en grandes vol\u00famenes.<\/li>\n                    <li><strong>L\u00f3gica Tabular:<\/strong> Manipulaci\u00f3n de tablas con FILTER, VALUES y DISTINCT.<\/li>\n                <\/ul>\n            <\/div>\n        <\/details>\n\n        <details class=\"modulo-v\">\n            <summary>\n                <div class=\"capa-titulo\">\n                    <span class=\"icono-v\">\ud83d\udd00<\/span>\n                    <span class=\"texto-v\">Fase 3: Condicionales y Funciones L\u00f3gicas (4h)<\/span>\n                <\/div>\n            <\/summary>\n            <div class=\"bloque-contenido\">\n                <ul>\n                    <li><strong>Toma de Decisiones:<\/strong> Implementaci\u00f3n de funciones IF, AND \/ OR.<\/li>\n                    <li><strong>Gesti\u00f3n de Errores:<\/strong> Uso de IFERROR para reportes limpios.<\/li>\n                    <li><strong>L\u00f3gica M\u00faltiple:<\/strong> Optimizaci\u00f3n de procesos con la funci\u00f3n SWITCH.<\/li>\n                <\/ul>\n            <\/div>\n        <\/details>\n\n        <details class=\"modulo-v\">\n            <summary>\n                <div class=\"capa-titulo\">\n                    <span class=\"icono-v\">\u26a1<\/span>\n                    <span class=\"texto-v\">Fase 4: Iteradores y Funci\u00f3n CALCULATE (8h)<\/span>\n                <\/div>\n            <\/summary>\n            <div class=\"bloque-contenido\">\n                <ul>\n                    <li><strong>Iteraci\u00f3n Avanzada:<\/strong> Dominio de funciones X (SUMX, AVERAGEX, COUNTX, MINX).<\/li>\n                    <li><strong>Potencia DAX:<\/strong> Uso profundo de la funci\u00f3n CALCULATE y CALCULATETABLE.<\/li>\n                    <li><strong>Modificaci\u00f3n de Filtros:<\/strong> Alteraci\u00f3n de contextos para c\u00e1lculos complejos.<\/li>\n                <\/ul>\n            <\/div>\n        <\/details>\n\n        <details class=\"modulo-v\">\n            <summary>\n                <div class=\"capa-titulo\">\n                    <span class=\"icono-v\">\ud83d\udcc8<\/span>\n                    <span class=\"texto-v\">Fase 5: Inteligencia de Filtros y Visualizaci\u00f3n (10h)<\/span>\n                <\/div>\n            <\/summary>\n            <div class=\"bloque-contenido\">\n                <ul>\n                    <li><strong>Funciones de Exclusi\u00f3n:<\/strong> Manipulaci\u00f3n total con ALL, ALLEXCEPT y ALLSELECTED.<\/li>\n                    <li><strong>Visualizaci\u00f3n de \u00c9lite:<\/strong> Storytelling con gr\u00e1ficos de \u00c1reas, L\u00edneas, TreeMaps y Anillos.<\/li>\n                    <li><strong>Comparativa Pro:<\/strong> An\u00e1lisis din\u00e1mico mediante gr\u00e1ficos de Barras y Columnas de seguimiento.<\/li>\n                    <li><strong>Proyecto Final:<\/strong> Integraci\u00f3n de funciones DAX avanzadas en Dashboards interactivos.<\/li>\n                <\/ul>\n            <\/div>\n        <\/details>\n    <\/div>\n<\/div>\n\n<style>\n.contenedor-temario-cedip {\n    max-width: 1200px;\n    margin: 50px auto;\n    padding: 0 20px;\n    font-family: 'Inter', sans-serif;\n}\n\n.titulo-exclusivo {\n    color: #004A31;\n    font-size: 2rem;\n    font-weight: 900;\n    text-align: center;\n    margin-bottom: 5px;\n}\n\n.bajada-titulo {\n    text-align: center;\n    color: #666;\n    margin-bottom: 40px;\n    font-size: 1.1rem;\n}\n\n.grid-temario-cedip {\n    display: grid;\n    grid-template-columns: repeat(auto-fit, minmax(320px, 1fr));\n    gap: 25px;\n}\n\n.modulo-v {\n    background: #ffffff;\n    border-radius: 18px;\n    border: 1px solid #e0e6e3;\n    transition: all 0.3s ease;\n    box-shadow: 0 4px 12px rgba(0,0,0,0.03);\n}\n\n.modulo-v summary {\n    padding: 22px;\n    list-style: none;\n    cursor: pointer;\n    outline: none;\n}\n\n.modulo-v summary::-webkit-details-marker { display: none; }\n\n.capa-titulo {\n    display: flex;\n    align-items: center;\n    gap: 15px;\n}\n\n.icono-v { font-size: 1.4rem; }\n\n.texto-v {\n    font-weight: 700;\n    color: #004A31;\n    font-size: 1rem;\n    line-height: 1.3;\n}\n\n.bloque-contenido {\n    padding: 0 25px 25px 55px;\n    border-top: 1px solid #f0f4f2;\n    margin-top: 5px;\n}\n\n.bloque-contenido ul {\n    margin: 15px 0 0 0;\n    padding: 0;\n    list-style: none;\n}\n\n.bloque-contenido li {\n    font-size: 0.92rem;\n    color: #4a4a4a;\n    padding: 8px 0;\n    position: relative;\n    border-bottom: 1px solid #f7f9f8;\n}\n\n.bloque-contenido li::before {\n    content: \"\u2192\";\n    color: #25d366;\n    position: absolute;\n    left: -20px;\n    font-weight: bold;\n}\n\n.modulo-v[open] {\n    border-color: #25d366;\n    box-shadow: 0 10px 30px rgba(0,74,49,0.08);\n    transform: translateY(-5px);\n}\n\n.modulo-v[open] .texto-v { color: #004A31; }\n\n@media (max-width: 768px) {\n    .grid-temario-cedip { grid-template-columns: 1fr; }\n    .titulo-exclusivo { font-size: 1.6rem; }\n}\n<\/style>\n\n\n\n<div class=\"wp-block-stackable-divider stk-block-divider stk-block stk-cb5cec2\" data-block-id=\"cb5cec2\"><hr class=\"stk-block-divider__hr\"\/><\/div>\n\n\n\n<section class=\"cierre-final-cedip\">\n    <div class=\"contenido-cierre-v\">\n        <div class=\"icono-flotante\">\ud83d\ude80<\/div>\n        <h2>\u00bfListo para el siguiente nivel?<\/h2>\n        <p>Consolida tu perfil profesional dominando el <strong>Lenguaje DAX<\/strong> avanzado. No te quedes solo con lo b\u00e1sico; convi\u00e9rtete en un experto en Business Intelligence con CEDIP Virtual.<\/p>\n        \n        <div class=\"caja-accion\">\n            <a href=\"https:\/\/wa.me\/593984357883?text=%C2%A1Hola%21%20%F0%9F%91%8B%20Me%20interesa%20inscribirme%20en%20el%20curso%20avanzado%20de%20*Power%20BI%202%3A%20Funciones%20QUERY%20y%20DAX*.%20%C2%BFPodr%C3%ADan%20darme%20m%C3%A1s%20detalles%20sobre%20la%20pr%C3%B3xima%20fecha%20de%20inicio%3F%20%F0%9F%93%8A\" \n               class=\"btn-whatsapp-final\" target=\"_blank\">\n               <span class=\"ws-icon\">\n                <svg viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" fill=\"currentColor\"><path d=\"M17.472 14.382c-.297-.149-1.758-.867-2.03-.967-.273-.099-.471-.148-.67.15-.197.297-.767.966-.94 1.164-.173.199-.347.223-.644.075-.297-.15-1.255-.463-2.39-1.475-.883-.788-1.48-1.761-1.653-2.059-.173-.297-.018-.458.13-.606.134-.133.298-.347.446-.52.149-.174.198-.298.298-.497.099-.198.05-.371-.025-.52-.075-.149-.669-1.612-.916-2.207-.242-.579-.487-.5-.669-.51-.173-.008-.371-.01-.57-.01-.198 0-.52.074-.792.372-.272.297-1.04 1.016-1.04 2.479 0 1.462 1.065 2.875 1.213 3.074.149.198 2.096 3.2 5.077 4.487.709.306 1.262.489 1.694.625.712.227 1.36.195 1.871.118.571-.085 1.758-.719 2.006-1.413.248-.694.248-1.289.173-1.413-.074-.124-.272-.198-.57-.347m-5.421 7.403h-.004a9.87 9.87 0 01-5.031-1.378l-.361-.214-3.741.982.998-3.648-.235-.374a9.86 9.86 0 01-1.51-5.26c.001-5.45 4.436-9.884 9.888-9.884 2.64 0 5.122 1.03 6.988 2.898a9.825 9.825 0 012.893 6.994c-.003 5.45-4.437 9.884-9.885 9.884m8.413-18.297A11.815 11.815 0 0012.05 0C5.495 0 .16 5.335.157 11.892c0 2.096.547 4.142 1.588 5.945L0 24l6.335-1.662c1.72.94 3.659 1.437 5.634 1.437h.005c6.558 0 11.894-5.335 11.897-11.893a11.821 11.821 0 00-3.48-8.413Z\"\/><\/svg>\n               <\/span>\n               QUIERO INSCRIBIRME AL NIVEL 2\n            <\/a>\n            <p class=\"horarios-v\">Atenci\u00f3n personalizada inmediata<\/p>\n        <\/div>\n    <\/div>\n<\/section>\n\n<style>\n.cierre-final-cedip {\n    background: #004A31; \n    padding: 80px 20px;\n    text-align: center;\n    border-radius: 30px;\n    margin: 60px auto;\n    max-width: 1100px;\n    color: white;\n    box-shadow: 0 20px 50px rgba(0,74,49,0.2);\n}\n\n.icono-flotante {\n    font-size: 3rem;\n    margin-bottom: 20px;\n    animation: bounce 2s infinite;\n}\n\n@keyframes bounce {\n    0%, 100% { transform: translateY(0); }\n    50% { transform: translateY(-10px); }\n}\n\n.cierre-final-cedip h2 {\n    font-size: 2.5rem;\n    font-weight: 900;\n    margin-bottom: 20px;\n    color: #fff;\n}\n\n.cierre-final-cedip p {\n    font-size: 1.2rem;\n    max-width: 700px;\n    margin: 0 auto 40px;\n    opacity: 0.9;\n    line-height: 1.6;\n}\n\n.btn-whatsapp-final {\n    display: inline-flex;\n    align-items: center;\n    gap: 15px;\n    background: #25d366;\n    color: white;\n    padding: 22px 45px;\n    border-radius: 50px;\n    text-decoration: none;\n    font-weight: 900;\n    font-size: 1.3rem;\n    transition: all 0.3s ease;\n    box-shadow: 0 10px 30px rgba(37,211,102,0.4);\n}\n\n.btn-whatsapp-final:hover {\n    background: #1ebe57;\n    transform: scale(1.05);\n    box-shadow: 0 15px 40px rgba(37,211,102,0.6);\n}\n\n.ws-icon svg {\n    display: block;\n}\n\n.horarios-v {\n    margin-top: 20px !important;\n    font-size: 0.85rem !important;\n    font-weight: 500;\n    letter-spacing: 1px;\n    text-transform: uppercase;\n}\n\n@media (max-width: 768px) {\n    .cierre-final-cedip {\n        border-radius: 0;\n        padding: 60px 20px;\n    }\n    \n    .cierre-final-cedip h2 {\n        font-size: 1.8rem;\n    }\n    \n    .btn-whatsapp-final {\n        width: 100%;\n        padding: 18px 25px;\n        font-size: 1.1rem;\n        box-sizing: border-box;\n        justify-content: center;\n    }\n}\n<\/style>\n","protected":false},"excerpt":{"rendered":"<p>ESPECIALIZACI\u00d3N AVANZADA Power BI 2: Funciones QUERY y DAX Consolida tus habilidades t\u00e9cnicas dominando a fondo el Lenguaje DAX y sus componentes avanzados. En este nivel, profundizamos en la iteraci\u00f3n de visualizaciones complejas y el modelado de datos de alto rendimiento para generar informes de inteligencia empresarial de nivel experto. Ejes Principales del Programa: DAX [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-905","page","type-page","status-publish","hentry"],"blocksy_meta":{"has_hero_section":"disabled","styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power BI 2: Funciones QUERY y DAX &#8211; CEDIP Virtual<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI 2: Funciones QUERY y DAX &#8211; CEDIP Virtual\" \/>\n<meta property=\"og:description\" content=\"ESPECIALIZACI\u00d3N AVANZADA Power BI 2: Funciones QUERY y DAX Consolida tus habilidades t\u00e9cnicas dominando a fondo el Lenguaje DAX y sus componentes avanzados. En este nivel, profundizamos en la iteraci\u00f3n de visualizaciones complejas y el modelado de datos de alto rendimiento para generar informes de inteligencia empresarial de nivel experto. Ejes Principales del Programa: DAX [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/\" \/>\n<meta property=\"og:site_name\" content=\"CEDIP Virtual\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/CEDIPcapacitaciones\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/Analisis-de-Datos.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/\",\"url\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/\",\"name\":\"Power BI 2: Funciones QUERY y DAX &#8211; CEDIP Virtual\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Analisis-de-Datos.png\",\"datePublished\":\"2026-04-15T00:56:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Analisis-de-Datos.png\",\"contentUrl\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Analisis-de-Datos.png\",\"width\":500,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/power-bi-2-funciones-query-y-dax\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI 2: Funciones QUERY y DAX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/#website\",\"url\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/\",\"name\":\"CEDIP Virtual | Escuela de Alto Rendimiento y Capacitaci\u00f3n Profesional\",\"description\":\"Liderazgo, Disciplina y Tecnolog\u00eda\",\"publisher\":{\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/#organization\"},\"alternateName\":\"CEDIP Escuela de Alto Rendimiento\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/#organization\",\"name\":\"CEDIP Virtual\",\"url\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/CEDIL-LOGO-WEB.png\",\"contentUrl\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/CEDIL-LOGO-WEB.png\",\"width\":131,\"height\":43,\"caption\":\"CEDIP Virtual\"},\"image\":{\"@id\":\"https:\\\/\\\/cedipvirtual.com\\\/webpage\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/CEDIPcapacitaciones\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI 2: Funciones QUERY y DAX &#8211; CEDIP Virtual","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/","og_locale":"es_ES","og_type":"article","og_title":"Power BI 2: Funciones QUERY y DAX &#8211; CEDIP Virtual","og_description":"ESPECIALIZACI\u00d3N AVANZADA Power BI 2: Funciones QUERY y DAX Consolida tus habilidades t\u00e9cnicas dominando a fondo el Lenguaje DAX y sus componentes avanzados. En este nivel, profundizamos en la iteraci\u00f3n de visualizaciones complejas y el modelado de datos de alto rendimiento para generar informes de inteligencia empresarial de nivel experto. Ejes Principales del Programa: DAX [&hellip;]","og_url":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/","og_site_name":"CEDIP Virtual","article_publisher":"https:\/\/www.facebook.com\/CEDIPcapacitaciones\/","og_image":[{"url":"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/Analisis-de-Datos.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/","url":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/","name":"Power BI 2: Funciones QUERY y DAX &#8211; CEDIP Virtual","isPartOf":{"@id":"https:\/\/cedipvirtual.com\/webpage\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/#primaryimage"},"image":{"@id":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/#primaryimage"},"thumbnailUrl":"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/Analisis-de-Datos.png","datePublished":"2026-04-15T00:56:42+00:00","breadcrumb":{"@id":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/#primaryimage","url":"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/Analisis-de-Datos.png","contentUrl":"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/Analisis-de-Datos.png","width":500,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/cedipvirtual.com\/webpage\/power-bi-2-funciones-query-y-dax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/cedipvirtual.com\/webpage\/"},{"@type":"ListItem","position":2,"name":"Power BI 2: Funciones QUERY y DAX"}]},{"@type":"WebSite","@id":"https:\/\/cedipvirtual.com\/webpage\/#website","url":"https:\/\/cedipvirtual.com\/webpage\/","name":"CEDIP Virtual | Escuela de Alto Rendimiento y Capacitaci\u00f3n Profesional","description":"Liderazgo, Disciplina y Tecnolog\u00eda","publisher":{"@id":"https:\/\/cedipvirtual.com\/webpage\/#organization"},"alternateName":"CEDIP Escuela de Alto Rendimiento","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cedipvirtual.com\/webpage\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/cedipvirtual.com\/webpage\/#organization","name":"CEDIP Virtual","url":"https:\/\/cedipvirtual.com\/webpage\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/cedipvirtual.com\/webpage\/#\/schema\/logo\/image\/","url":"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/CEDIL-LOGO-WEB.png","contentUrl":"https:\/\/cedipvirtual.com\/webpage\/wp-content\/uploads\/2026\/04\/CEDIL-LOGO-WEB.png","width":131,"height":43,"caption":"CEDIP Virtual"},"image":{"@id":"https:\/\/cedipvirtual.com\/webpage\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/CEDIPcapacitaciones\/"]}]}},"_links":{"self":[{"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/pages\/905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/comments?post=905"}],"version-history":[{"count":2,"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/pages\/905\/revisions"}],"predecessor-version":[{"id":907,"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/pages\/905\/revisions\/907"}],"wp:attachment":[{"href":"https:\/\/cedipvirtual.com\/webpage\/wp-json\/wp\/v2\/media?parent=905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}