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.
Hola
Tengo una tabla de fechas que evoca columnas como
Fecha | WeekOfYear | WeekOfYearNumber |
20.12.20 | WK 51/20 | 202051 |
27.12.20 | WK 52/20 | 202052 |
03.01.21 | WK 53/20 | 202053 |
Solved! Go to Solution.
Hay @dats
Cree dos medidas como:
LFY week of year num =
var _yearnum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
LEFT(MAX('Table'[WeekOfYearNumber]),4),
LEFT(MAX('Table'[WeekOfYearNumber]),4)-1
)
var _weeknum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)+1
)
return
CONCATENATE(_yearnum,IF(_weeknum<10,CONCATENATE(0,_weeknum),_weeknum))
week of LFY =
var _yearnum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
LEFT(MAX('Table'[WeekOfYearNumber]),4),
LEFT(MAX('Table'[WeekOfYearNumber]),4)-1
)
var _weeknum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)+1
)
return
CONCATENATE(CONCATENATE("WK",CONCATENATE(IF(_weeknum<10,CONCATENATE(0,_weeknum),_weeknum),"/")),RIGHT(_yearnum,2))
Aquí está la salida:
Aquí está la demostración, por favor pruébela: Condicionalmente Cambie la base de cálculo para la semana pasada año
Saludos
Enlace
Hay @dats
Cree dos medidas como:
LFY week of year num =
var _yearnum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
LEFT(MAX('Table'[WeekOfYearNumber]),4),
LEFT(MAX('Table'[WeekOfYearNumber]),4)-1
)
var _weeknum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)+1
)
return
CONCATENATE(_yearnum,IF(_weeknum<10,CONCATENATE(0,_weeknum),_weeknum))
week of LFY =
var _yearnum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
LEFT(MAX('Table'[WeekOfYearNumber]),4),
LEFT(MAX('Table'[WeekOfYearNumber]),4)-1
)
var _weeknum=
IF(
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52>0,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)-52,
RIGHT(MAX('Table'[WeekOfYearNumber]),2)+1
)
return
CONCATENATE(CONCATENATE("WK",CONCATENATE(IF(_weeknum<10,CONCATENATE(0,_weeknum),_weeknum),"/")),RIGHT(_yearnum,2))
Aquí está la salida:
Aquí está la demostración, por favor pruébela: Condicionalmente Cambie la base de cálculo para la semana pasada año
Saludos
Enlace
@dats, no muy claro. Normalmente uso rango de la semana en la fecha de inicio de la semana o YYYYWW para tratar con la semana.
Vea si eso puede ayudar
Power BI — Semana a semana y WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
O
¿Puede compartir datos de ejemplo y salida de ejemplo en formato de tabla? O una muestra de pbix después de eliminar datos confidenciales.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |