Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Consecutive dates

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 di...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.  I have worked on the dates only.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ashish,

 

Data

IdM ARMS Ref Start D/T
562455AO-PR-22-00087111/10/2022 1:30:00 AM
562455AO-PR-22-00087113/10/2022 1:30:00 AM
548988AO-PR-22-00084110/12/2022 12:00:00 AM
548988AO-PR-22-00084110/12/2022 1:30:00 AM
548988AO-PR-22-00084111/12/2022 12:00:00 AM
548988AO-PR-22-00084112/12/2022 12:00:00 AM
542031AO-PR-22-00081324/10/2022 1:30:00 AM
542031AO-PR-22-00081325/10/2022 1:30:00 AM
542031AO-PR-22-00081326/10/2022 1:30:00 AM
542031AO-PR-22-00081327/10/2022 1:30:00 AM
542031AO-PR-22-00081328/10/2022 1:30:00 AM
541821AO-PR-22-00081231/08/2022 9:00:00 PM
467841AO-PR-22-00021907/11/2022 9:00:00 PM
467841AO-PR-22-00021908/11/2022 9:00:00 PM
467841AO-PR-22-00021909/11/2022 9:00:00 PM
467841AO-PR-22-00021910/11/2022 9:00:00 PM
455821AO-PR-22-00018110/12/2022 12:00:00 AM
455821AO-PR-22-00018110/12/2022 1:30:00 AM
455821AO-PR-22-00018111/12/2022 12:00:00 AM
455821AO-PR-22-00018112/12/2022 12:00:00 AM
429216AO-PR-22-00013226/11/2022 9:00:00 PM
429216AO-PR-22-00013227/11/2022 9:00:00 PM

 

 

Result

 

M ARMS Ref

Start Date       Start TimeFinish DateFinish Time
AO-PR-22-000132Sat, 26 Nov 2221:00Mon, 28 Nov 224:00
AO-PR-22-000181Sat, 10 Dec 221:30Mon, 12 Dec 223:00
AO-PR-22-000219
(4no)		Mon, 7 Nov 2221:00Fri, 11 Nov 224:00
AO-PR-22-000812Wed, 31 Aug 2221:00Thu, 1 Sep 224:00
AO-PR-22-000813Mon, 24 Oct 221:30Fri, 28 Oct 224:00
AO-PR-22-000841Sat, 10 Dec 221:30Mon, 12 Dec 223:00
AO-PR-22-000871Tue, 11 Oct 221:30Tue, 11 Oct 224:00
AO-PR-22-000871Thu, 13 Oct 221:30Thu, 13 Oct 224:00
     
     
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

You may download my PBI file from here.  I have worked on the dates only.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Ashish,

     

    Thank you s much.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      You are welcome.