Curso Power BI: Uso de Inteligencia Artificial y Creación de Tabla Calendario con DAX

In this hands-on Power BI Desktop session, we explore how to enhance our reports using Artificial Intelligence tools and how to properly structure a relational model. In this video, you will learn: Enabling AI tools: How to activate and restore the default AI visuals in Power BI, including the Questions and Answers feature. Creating a Calendar Table with AI: We use Gemini to generate a tailored DAX code, explaining step-by-step how to modify the minimum and maximum date variables according to the relational model (using the issue and payment dates from our invoice table). Advanced time columns: We learn how to structure the table to group data by semester, bimonthly period, and week of the month. Measures and Metrics with DAX: Creating a dedicated table for measures and using the SUMX iterator function combined with RELATED to efficiently calculate total sales by multiplying quantity by unit price. Ideal for data analysts who want to optimize the design of their dashboards and automate code creation using artificial intelligence assistants.