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 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?

    • dmutka's avatar
      dmutka
      Frequent Visitor
      7 years ago
      No, it can vary. Monthly, Every Other Month, Weekly, Every Other Week, Twice or Three Times Weekly.
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        So there should be another 2 table which should list down the Customer wise service frequency.  Please share all possible information for solving this problem.  Also, for the file that you shared above, please show the exact dates you are expecting for any 2-3 customers (who have different service frequencies).  If at all, i can solve the problem, I'd like to compare my answers with yours before i can share the solution file with you.