Forum Discussion
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...
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
Hi Anonymous thank you for your reply.
I have included 3 images below, current data relationships (all linked by ID number), proposed table (as per your screenshot) and a desired outcome on the report, I have done this already for 1st website data where there was only 1 date so it was straight forward. let me know if you need me to provide anything else.
thanks
Nick
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
Rena!!!
I can't thank you enough, that has worked and its exactly what I was after. thank you again.
I'm assuming that as new data is added to those columns my new table just automatically updates?
thank you again, so much.
Nick