Forum Discussion

dmutka's avatar
dmutka
Frequent Visitor
7 years ago

Calendar Based on Last Date

I am trying to create a calendar in Power Bi that predicts a customers future service dates based on the last service date that we have recorded for them. I am able to create a a measure that shows t...
Need Help
Show and Tell
Tutorial Requests
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

You have shared the desired outcome, not the raw data.  Please share that as well.

dmutka's avatar
dmutka
Frequent Visitor
7 years ago

Ashish_Mathur Here is a link to Sample data. As mentioned, I am looking up the customers last service date, and then trying to create a new table based off the customer selected/service frequency, that will show predicted service dates in the future. Any help, if possible, would be appreciated.

 

Thanks!

 

Sample File

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

    • dmutka's avatar
      dmutka
      Frequent Visitor
      7 years ago

      Ashish_Mathur  I appreciate you taking the time to help me with my problem, but it is not what I am looking for. I am trying to take the future dates i.e. the next service dates and place them in same column as the last pick up date. So if I filtered the table to Customer A the table would populate like below:

      Customer NameLast Pickup DateNext Pickup Date
      Customer A5/1/20196/1/2019
      Customer A6/1/20197/1/2019
      Customer A7/1/20198/1/2019

       

      As mentioned, I know how to move a date a ceratin interval by creating a new column or measure, but i do not know how to then organize it into a similar manner as shown above.

       

      Thanks!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

        Will the service frequency of all customers be monthly?