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.
Tengo datos con un campo de fecha
4/1/2020
10/15/2019
1/1/2019
Necesito una columna que contenga el valor del trimestre anterior. año puede estar en la misma columna o en una columna diferente
2020 Q1
2019 Q3
Q4 2018
Respectivamente
¡Gracias!
Solved! Go to Solution.
Hola @Fair-UL ,
Crear una nueva columna
Column =
var _year = Year('Table (3)'[Date])
var _quarter = QUARTER('Table (3)'[Date])
RETURN
SWITCH(
TRUE(),
_quarter - 1 = 0 , _year-1 & " Q" & 4,
_year & " Q" & _quarter-1
)
saludos
Harsh Nathani
Hola @Fair-UL ,
Crear una nueva columna
Column =
var _year = Year('Table (3)'[Date])
var _quarter = QUARTER('Table (3)'[Date])
RETURN
SWITCH(
TRUE(),
_quarter - 1 = 0 , _year-1 & " Q" & 4,
_year & " Q" & _quarter-1
)
saludos
Harsh Nathani
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
1 | |
1 |