Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help to avoid circular reference

Excel To HTML using codebeautify.org Sheet Name :- Sheet1

Hi all,

 

i have data like below table when i select Date: 12/24/2018 by using date filter 

i want to show created Ticket details and clocked ticket details in seperate table 

how can i achive this logic? 

 

 

Ticket IDCreated DateStatusStatus Date
ID112-24-18Closed12-24-18
ID212-24-18Inprogress12-24-18
ID312-24-18Hold12-24-18
ID412-24-18Closed12-24-18
ID512-24-18Closed12-24-18
ID612-23-18Closed12-23-18
ID712-23-18Closed12-23-18
ID812-23-18Closed12-24-18
ID912-23-18Closed12-24-18
ID1012-23-18Inprogress12-24-18
ID1112-23-18Hold12-23-18
    
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

    Based on my test, you could try this way as below:

    Step1:

    In Edit Queries, select Created Date column and Status Date column, then click Transform->Unpivot Columns

    Step2:

    Apply&Close

     

    Step3:

    Create a relationship with date table by Value

    Result:

     

    Best Regards,
    Lin

     

     

     

2 Replies