Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ID | Created Date | Status | Status Date |
ID1 | 12-24-18 | Closed | 12-24-18 |
ID2 | 12-24-18 | Inprogress | 12-24-18 |
ID3 | 12-24-18 | Hold | 12-24-18 |
ID4 | 12-24-18 | Closed | 12-24-18 |
ID5 | 12-24-18 | Closed | 12-24-18 |
ID6 | 12-23-18 | Closed | 12-23-18 |
ID7 | 12-23-18 | Closed | 12-23-18 |
ID8 | 12-23-18 | Closed | 12-24-18 |
ID9 | 12-23-18 | Closed | 12-24-18 |
ID10 | 12-23-18 | Inprogress | 12-24-18 |
ID11 | 12-23-18 | Hold | 12-23-18 |
Solved! Go to Solution.
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
I'm not understanding the dilemma here exactly. What end result are you looking for?
Take a look at these two Quick Measures as I think you want something like them??
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |