Forum Discussion

MDEL's avatar
MDEL
Regular Visitor
8 years ago
Solved

Combine two columns in the same table

Hi All,  Thanks for the help,  I have 2 columns both contains 'Dates' for different category. I need to create new column to combine both columns and be able to query the data using the new column....
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    MDEL,

    Create a column as shown in the following screenshot.

    Column = IF(ISBLANK(YourTable[WHDD]),YourTable[PDD],YourTable[WHDD])



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago



PDD column have Dates for some records

WHDD column have Dates for different records

I want to combine both columns into one column to be able to query the Data using the combined column.

the table contains 65 columns and thousands of records. 

MDEL,

Are PDD column and WHDD column in same table? If so, what logic do you use to create the new combine column(e.g. if PDD column is greater than WHDD, then combine column should be equal to PDD column, otherwise, it should be equal to WHDD column)?

Regards,
Lydia

MDEL's avatar
MDEL
Regular Visitor
8 years ago

Hi Lydia

I want PDD and WHDD values to be copied to the new field as it is please see example below

Name          PDD          WHDD         NEW Field

Raw1            658                               658

Raw2            5685                             5685

Raw3            699                               699

Raw4                            257               257

Raw5                            123                123

Raw6                             666               666

 

New Field contains both values from PDD and WHDD

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    MDEL,

    Create a column as shown in the following screenshot.

    Column = IF(ISBLANK(YourTable[WHDD]),YourTable[PDD],YourTable[WHDD])



    Regards,
    Lydia