Columna calculada

[carlosayala_9]

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!

[amitchandak · Accepted solution]

@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)) )

[Anonymous · Accepted solution]

Hi @carlosayala_9 ,

Does the above reply solve the problem?

If it works, please consider to mark it as a solution.

Best Regards,

Jay

[amitchandak · Accepted solution]

@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)) )