Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creating a new column with data from another column sorted by a second column

Hello Pros',

I need to create a new column with a StatusHistoryDate that has a StatusHistory = 10.

The new column should contain only the date that has StatusHistory 10.

 

Please help 🙂

  • Is 'Status10Date' a New Measure or New Column?

     

    Adding a new column, you can directly add IF logic looking at every row, and return a desired column.

     

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    Yes, I need a new column.

    Thank you so much fhill 👍

2 Replies

  • fhill's avatar
    fhill
    Icon for Resident Rockstar rankResident Rockstar

    Is 'Status10Date' a New Measure or New Column?

     

    Adding a new column, you can directly add IF logic looking at every row, and return a desired column.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes, I need a new column.

      Thank you so much fhill 👍