Forum Discussion
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 ...
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
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