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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Greg.

     

    thank you for coming back to me. my source data is from SQL Server. The data I'm using is split over 5 tables, however, I only require 6 or 7 specific columns.  I want to amalgamate those dates so I essentially have 1 date column that contains all the data from 2nd, 3rd and 4th website launched. does that make sense? 

     

    thanks

     

    Nick 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      Maybe we can deal with the source data first. Could you please provide the structures of these 5 tables in SQL Server? Which table these required columns are from? Please also provide some sample data(exclude sensitive data) and expected results just like the below screenshot. 

      Best Regards

      Rena

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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