Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am having an issue with my report, I have a table with a reference and start date (the earliest date is the start date and the latest date is the end date), Reference numbers are duplicated with different start and end dates, the report is working for those have a consecutive date but for those having the gap between start and end date is not working correctly) I want to show them in a different row if there is a gap between the start and end dates.
Solved! Go to Solution.
Hi,
You may download my PBI file from here. I have worked on the dates only.
Hope this helps.
Hi,
Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result clearly.
Hi Ashish,
Data
Id | M ARMS Ref | Start D/T |
562455 | AO-PR-22-000871 | 11/10/2022 1:30:00 AM |
562455 | AO-PR-22-000871 | 13/10/2022 1:30:00 AM |
548988 | AO-PR-22-000841 | 10/12/2022 12:00:00 AM |
548988 | AO-PR-22-000841 | 10/12/2022 1:30:00 AM |
548988 | AO-PR-22-000841 | 11/12/2022 12:00:00 AM |
548988 | AO-PR-22-000841 | 12/12/2022 12:00:00 AM |
542031 | AO-PR-22-000813 | 24/10/2022 1:30:00 AM |
542031 | AO-PR-22-000813 | 25/10/2022 1:30:00 AM |
542031 | AO-PR-22-000813 | 26/10/2022 1:30:00 AM |
542031 | AO-PR-22-000813 | 27/10/2022 1:30:00 AM |
542031 | AO-PR-22-000813 | 28/10/2022 1:30:00 AM |
541821 | AO-PR-22-000812 | 31/08/2022 9:00:00 PM |
467841 | AO-PR-22-000219 | 07/11/2022 9:00:00 PM |
467841 | AO-PR-22-000219 | 08/11/2022 9:00:00 PM |
467841 | AO-PR-22-000219 | 09/11/2022 9:00:00 PM |
467841 | AO-PR-22-000219 | 10/11/2022 9:00:00 PM |
455821 | AO-PR-22-000181 | 10/12/2022 12:00:00 AM |
455821 | AO-PR-22-000181 | 10/12/2022 1:30:00 AM |
455821 | AO-PR-22-000181 | 11/12/2022 12:00:00 AM |
455821 | AO-PR-22-000181 | 12/12/2022 12:00:00 AM |
429216 | AO-PR-22-000132 | 26/11/2022 9:00:00 PM |
429216 | AO-PR-22-000132 | 27/11/2022 9:00:00 PM |
Result
M ARMS Ref | Start Date | Start Time | Finish Date | Finish Time |
AO-PR-22-000132 | Sat, 26 Nov 22 | 21:00 | Mon, 28 Nov 22 | 4:00 |
AO-PR-22-000181 | Sat, 10 Dec 22 | 1:30 | Mon, 12 Dec 22 | 3:00 |
AO-PR-22-000219 (4no) | Mon, 7 Nov 22 | 21:00 | Fri, 11 Nov 22 | 4:00 |
AO-PR-22-000812 | Wed, 31 Aug 22 | 21:00 | Thu, 1 Sep 22 | 4:00 |
AO-PR-22-000813 | Mon, 24 Oct 22 | 1:30 | Fri, 28 Oct 22 | 4:00 |
AO-PR-22-000841 | Sat, 10 Dec 22 | 1:30 | Mon, 12 Dec 22 | 3:00 |
AO-PR-22-000871 | Tue, 11 Oct 22 | 1:30 | Tue, 11 Oct 22 | 4:00 |
AO-PR-22-000871 | Thu, 13 Oct 22 | 1:30 | Thu, 13 Oct 22 | 4:00 |
Hi,
You may download my PBI file from here. I have worked on the dates only.
Hope this helps.
Hi Ashish,
Thank you s much.
You are welcome.