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 problemas para crear una tabla que contiene una fecha y unos datos, la fecha es una medida que me da la fecha del dia siguiente despues de seleccionar una fecha en el selector, es para calcular una proyeccion:
La tabla que quiero calcular tiene esta formula
al querer crear una columna con la fecha que calcule, me sale esto, la fecha 31/12/1899,
Quiza estoy usando mal el contexto y si alguien me puede ayudar con esto u otra forma, es para colocarlo en una visualizacion de linea para ver la proyeccion.
Solved! Go to Solution.
Hi @CesarUG ,
There is no error in your dax formula, this is due to the nature of the calculation table, he can't get the date values that change based on the slicer values, he is rendered statically in the table view. But you can create dummy table in measure and this dummy table date is displayed normally.
Measure =
var _table=ADDCOLUMNS(GENERATESERIES(0,23,1),"Hora",[Value],"cantidad",1,"date",[prueba fecha])
RETURN MAXX(_table,[date])
Or you can display the table and date measure directly in the visual object.
If you want to create a table display, then you need to implement it in the power query.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @CesarUG ,
There is no error in your dax formula, this is due to the nature of the calculation table, he can't get the date values that change based on the slicer values, he is rendered statically in the table view. But you can create dummy table in measure and this dummy table date is displayed normally.
Measure =
var _table=ADDCOLUMNS(GENERATESERIES(0,23,1),"Hora",[Value],"cantidad",1,"date",[prueba fecha])
RETURN MAXX(_table,[date])
Or you can display the table and date measure directly in the visual object.
If you want to create a table display, then you need to implement it in the power query.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, me ayudo la solucion
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
19 | |
14 |