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 base de datos en la cual tengo un campo de Año/Semana (no es tipo fecha) y quiero llevarme la informacion de la columna Late de la semana 2019.06 a la semana siguiente 2019.07... Con que formula puedo bajar este dato de una semana a otra??
Quiero calcular un Late N-1
Año/ Semana | Planta | Material | Conf | Real | Late | Late N-1 |
2019.06 | S1 | SKU 2 | 100 | 90 | -10 | |
2019.07 | S1 | SKU 2 | 100 | 130 | 11 | -10 |
2019.08 | S1 | SKU 2 | 0 | 120 | 5 | 11 |
2019.09 | S1 | SKU 2 | 100 | 80 | -20 | 5 |
Agradezco sus comentarios
Solved! Go to Solution.
@Ely ,
So your requirement is to achieve the aggregation value in previous year? You may use PREVIOUSYEAR() or SAMEPERIODLASTYEAR(), please refer to:
https://docs.microsoft.com/en-us/dax/previousyear-function-dax
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Ely ,
So your requirement is to achieve the aggregation value in previous year? You may use PREVIOUSYEAR() or SAMEPERIODLASTYEAR(), please refer to:
https://docs.microsoft.com/en-us/dax/previousyear-function-dax
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |