Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ra20067
Helper I
Helper I

Ayuda de la función de conmutación

Estoy intentando cambiar la función para crear una nueva columna.

SWITCH(Query1[Month_New],"Enero",01,"Febrero",02,"Marzo",03,"Abril",04,"Mayo",05,"Junio",06,"Julio",07,"Agosto",8,"Septiembre",9,"Octubre",10,"Noviembre",11,"Diciembre",12)
en la salida no estoy geeting 01 para el janurary. Estoy recibiendo 1 sólo
4 REPLIES 4
az38
Community Champion
Community Champion

Hola @ra20067

tratar de usar cuotas

SWITCH(Query1[Month_New],
"January","01",
"February","02",
...,
"12")

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

No está funcionando

az38
Community Champion
Community Champion

@ra20067

también cambie el tipo de columna a Texto en la cinta de herramientas Columna


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Gracias por la solución

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.