locked
DAX Question: copy column value but change at certain interval (text) RRS feed

  • Question

  • I would like to copy the rows from the first column to the second. 

    Whenever the logic comes to a row with "VC" I would like "VC" copied instead until the next "VC" value. 

    Then, it returns to copying the row in the first column.

     

    Column (Value to return)
    XX XX
    XX XX
    XX XX
    XX XX
    VC VC
    BY VC
    BY VC
    BY VC
    BY VC
    BY VC
    VC VC
    BY BY
    BY BY
    BY BY
    BY BY
    BY BY
    VC VC
    BY VC
    XX VC
    VC VC
    XX XX
    XX XX
    Tuesday, April 7, 2020 12:35 PM