Forum Discussion

sarath5140's avatar
sarath5140
Helper I
7 years ago
Solved

Trend analysis

Hi, Can someone help me in solving my problem.   I have two tables and both are not related to each other   Table A Data:   ID                   DateTime                Title 1 7/20/2019 6...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi sarath5140 ,

     

    Create a table with unique values of DateTime from table A and Table B. Use this new table to make the relationship between both tables then add this to the x-axis and the count ID from table A and Table B on your chart.

     

    Check PBIX file attach.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago

Hi sarath5140 ,

 

Create a table with unique values of DateTime from table A and Table B. Use this new table to make the relationship between both tables then add this to the x-axis and the count ID from table A and Table B on your chart.

 

Check PBIX file attach.

 

Regards,

MFelix

  • sarath5140's avatar
    sarath5140
    Helper I
    7 years ago

    Hi, Thanks for your reply.

     

    I have tried the below query for getting the distinct dates from two tables, but when converting the column datatype to datetime somehow the dates are not matching.

     

    For example, my table A  datetime column one value looks like this 2/26/2019 10:10:41 AM 

     

    after transforming the datatype to datetime using the below formula

    {

    Table.TransformColumnTypes(#"Renamed Columns",{{"CreateDate", type datetime}})

     

    now my datetime in the merged table looks like this

    2/26/2019 3:40:41 PM 

     

    I think it is taking the GMT time after conversion and because of this all the datetime values are not matching and in axis of trend not showing any dates. Could you please help in getting the exact datetime match in my trend