Forum Discussion

carlosayala_9's avatar
carlosayala_9
Frequent Visitor
4 years ago
Solved

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 m...
  • amitchandak's avatar
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    Hi carlosayala_9 ,

     

    Does the above reply solve the problem?

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

     

    Best Regards,

    Jay