Forum Discussion

Navaneetharaju_'s avatar
Navaneetharaju_
Icon for Helper II rankHelper II
2 years ago

Create Future run count Report or measure

Hi All, 

Ahmedx 

 

I want to create a report like train railway system. if we want to travel one place to another place. will have a multiple trains in that day, some are special train that only available on two days interval or two weeks interval or monthly interval, some local train may run and reach the destination multiple times in a day.

 

but while introduce or launch the train we have a train details like below,

 

Train Name - Train 1

Train Start date - 24-jan-2024

Train Start Time - 12:00 PM

Runs - days

repeat - 1 (days and 1 means it will run daily 12:00 PM)

 

I want to create a power bi report to find the selected date this train will run or not.

If I select only one date in dropdown (31-jan-2024)

This train count should show in 12;00 - 01:00 time bucket.

 

if i select any future like 25-Jul-2024, that also it should show.

 

how can we acheive this, we don't have a run history data based on the intervals only we have find the count on the selected data.

 

One more scenarion

 

Train Name - Train 2

Train Start date - 24-jan-2024

Train Start Time - 08:00 AM

Runs - Weekly

repeat - 1 (weekly and 1 means it will run weekly once at 08:00 AM)

 

24-Jan-2024 is wednesday, after 7 only it will run.

 

between the 25-jan-2024-31st-Jan-2024 it wont run(means this count shouldn't come on that between dates)

 

I hope, I clearly explain the requirement

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Navaneetharaju_ 

     

    Can you provide detailed sample pbix and the results you expect? So that I can help you better.  Please remove any sensitive data in advance.

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Navaneetharaju_'s avatar
      Navaneetharaju_
      Icon for Helper II rankHelper II
      2 years ago

      Hi Anonymous ,

       

      I have shared the Open_Google_sheet link for the document.

      Link - https://docs.google.com/spreadsheets/d/19b5dXg36tAxcv7_79Ho86fZi3fpj1r7a/edit?usp=drivesdk&ouid=102699603900763880895&rtpof=true&sd=true

       

      the above i have only mentioned for few scenario, the excel file that contains multiple scenarios.

       

      Repeat_by field contains what type of intervel(days, weeks, months, years, minutes)

      Repeat_every it gives frequency (1, 2, 3 etc Ex: One day once, weekly intervel, montly once or monthly intervel , yearly once, Minutes occurance even single day itself it runs multiple times and it will once meet the end occurance on that day)

      End date : task run end date( Task 1 end at after some days)

       

      I have attached the link, this will fine to help me.