Solved: Cómo convertir esto a Date

venkatasuresh_g · ‎06-25-2020

Hola

¿Cómo puedo convertir esto a una fecha "18-WK01" , que es 2018-Week01

Gracias por tu ayuda

Suresh Guddanti

az38 · ‎06-25-2020

si necesita mostrar los lunes de cada semana pruebe esta columna

Column = 
var _startYear= DATE(2000 + VALUE(LEFT([Date],2)),1,1)
var _startDay = IF(WEEKDAY(_startYear,1) = 2, _startYear + 7*(VALUE(RIGHT([Date],2)) - 1), _startYear + 7*VALUE(RIGHT([Date],2)))
RETURN
_startDay - WEEKDAY(_startDay,2) +1

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

View solution in original post

az38 · ‎06-25-2020

Hola @venkatasuresh_g

si necesita mostrar los lunes de cada semana pruebe esta columna

Column = 
var _startYear= DATE(2000 + VALUE(LEFT([Date],2)),1,1)
var _startDay = IF(WEEKDAY(_startYear,1) = 2, _startYear + 7*(VALUE(RIGHT([Date],2)) - 1), _startYear + 7*VALUE(RIGHT([Date],2)))
RETURN
_startDay - WEEKDAY(_startDay,2) +1

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

venkatasuresh_g · ‎06-25-2020

Muchas gracias

Cómo convertir esto a Date

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024