Forum Discussion

eduse07's avatar
eduse07
Icon for Helper I rankHelper I
5 years ago
Solved

Nueva columna copiar datos

Hola a todos.   Estoy trabajando con una consulta llamada "Conformacion ICO", en la cual busco crear una nueva columna que me tome el elemento resaltado en la columa "ICO" y me lo replique para tod...
columns
DAX
Need Help DAX
Show and Tell
  • ERD's avatar
    ERD
    5 years ago

    eduse07 ,

    you can try this measure:

    CorrectID =
VAR currentDoc = MAX ( T[Doc] )
RETURN
    CALCULATE (
        MAX ( T[ID] ),
        LEFT ( T[ID], LEN ( "03-0178" ) ) = "03-0178",
        T[Doc] = currentDoc,
        ALL ( T[Date] )
    )

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
5 years ago

What is the logic behind this? You need to choose values with name starting from "03-0178" for each Documento?

  • eduse07's avatar
    eduse07
    Icon for Helper I rankHelper I
    5 years ago

    yes, that is precisely what i must do 

    • ERD's avatar
      ERD
      Icon for Community Champion rankCommunity Champion
      5 years ago

      eduse07 ,

      you can try this measure:

      CorrectID =
VAR currentDoc = MAX ( T[Doc] )
RETURN
    CALCULATE (
        MAX ( T[ID] ),
        LEFT ( T[ID], LEN ( "03-0178" ) ) = "03-0178",
        T[Doc] = currentDoc,
        ALL ( T[Date] )
    )

      If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

      • eduse07's avatar
        eduse07
        Icon for Helper I rankHelper I
        5 years ago

        Sorry fo the delay, this funcionated for me. Thanks