Forum Discussion
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...
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 Name | Last Pickup Date | Next Pickup Date |
| Customer A | 5/1/2019 | 6/1/2019 |
| Customer A | 6/1/2019 | 7/1/2019 |
| Customer A | 7/1/2019 | 8/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!