Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with combining dates

Hi All Completely new to the forum so thanks in advance for any help you can give me.  I'm trying to combine some dates and some fields together into the same report. Structure of data below.   2...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    You can create one calculated table as below:

    Table = SUMMARIZECOLUMNS(
'TBL CONTACT'[ID],
'TBL CONTACT'[STATUS],
"DATE LAUNCHED",MAX(MAX(MAX('CONTACTABLE 1'[2ND WEBSITE LAUNCHED]),MAX('CONTACTABLE 1'[3RD WEBSITE LAUNCHED])),MAX('CONTACTABLE 2'[4TH WEBSITE LAUNCHED])),
"DATE ORDERED",MAX(MAX(MAX('TBL CONTACT'[2ND WEBSITE ORDERED]),MAX('CONTACTABLE 1'[3RD WEBSITE ORDERED])),MAX('CONTACTABLE 2'[4TH WEBSITE ORDERED])),
"UOP",MAX(MAX(MAX('CONTACTABLE 4'[2ND WEBSITE UOP]),MAX('CONTACTABLE 4'[3RD WEBSITE UOP])),MAX('CONTACTABLE 4'[4TH WEBSITE UOP])))

    Best Regards

    Rena