Forum Discussion
Columna calculada
Hola queria consultarles, hice una medida que me da la diferencia en dias sobre dos fechas (DATEDIFF) pero cuando pongo la medida dentro de la tabla me genera un solo valor repetido para todas y no me la acomoda por el filtro que estoy aplicando en la tabla y distribuye la cantidad......alguno que me pueda ayudar??
¡Gracias!
carlosayala_9 , In such case the most suitable is a new column
datediff([Porject Start Date], [project End Date], day)
If you create sumx measure , it should not show in table
Sumx(Table, datediff([Porject Start Date], [project End Date], day))
or
Sumx(Values(Table[PruBa3]) ,calculate( datediff(Min([Porject Start Date]), Max([project End Date]), day)) )
Hi carlosayala_9 ,
Does the above reply solve the problem?
If it works, please consider to mark it as a solution.
Best Regards,
Jay
2 Replies
- amitchandak
Super User
carlosayala_9 , In such case the most suitable is a new column
datediff([Porject Start Date], [project End Date], day)
If you create sumx measure , it should not show in table
Sumx(Table, datediff([Porject Start Date], [project End Date], day))
or
Sumx(Values(Table[PruBa3]) ,calculate( datediff(Min([Porject Start Date]), Max([project End Date]), day)) )
Hi carlosayala_9 ,
Does the above reply solve the problem?
If it works, please consider to mark it as a solution.
Best Regards,
Jay