Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hola! Tengo la siguiente tabla:
La fecha está en español con formato mmm-yy y no lo reconoce para pasar a formato fecha. Cuál es la forma más simple convertir esto a fecha?
Solved! Go to Solution.
Hi @AntoPasq ,
You can create a calculated column as below to get it, please find the details in the attachment.
DateEN =
VAR DayOfTheDate = 1
VAR YearOfTheDate =
VALUE ( RIGHT ( 'Table'[Mes], 2 ) )
VAR MidPortion =
LEFT ( 'Table'[Mes], 3 )
VAR MonthOfTheDate =
SWITCH (
TRUE (),
MidPortion = "Ene", 1,
MidPortion = "Feb", 2,
MidPortion = "Mar", 3,
MidPortion = "Abr", 4,
MidPortion = "May", 5,
MidPortion = "Jun", 6,
MidPortion = "Jul", 7,
MidPortion = "Ago", 8,
MidPortion = "Sep", 9,
MidPortion = "Oct", 10,
MidPortion = "Nov", 11,
MidPortion = "Dic", 12,
0
)
RETURN
DATE ( 2000 + YearOfTheDate, MonthOfTheDate, DayOfTheDate )
Best Regards
Hi @AntoPasq ,
You can create a calculated column as below to get it, please find the details in the attachment.
DateEN =
VAR DayOfTheDate = 1
VAR YearOfTheDate =
VALUE ( RIGHT ( 'Table'[Mes], 2 ) )
VAR MidPortion =
LEFT ( 'Table'[Mes], 3 )
VAR MonthOfTheDate =
SWITCH (
TRUE (),
MidPortion = "Ene", 1,
MidPortion = "Feb", 2,
MidPortion = "Mar", 3,
MidPortion = "Abr", 4,
MidPortion = "May", 5,
MidPortion = "Jun", 6,
MidPortion = "Jul", 7,
MidPortion = "Ago", 8,
MidPortion = "Sep", 9,
MidPortion = "Oct", 10,
MidPortion = "Nov", 11,
MidPortion = "Dic", 12,
0
)
RETURN
DATE ( 2000 + YearOfTheDate, MonthOfTheDate, DayOfTheDate )
Best Regards
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
67 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |