Grouping data based on months

[Anonymous]

I need help to model and display the data in visual - I have a table having  column with vechileno and another column with the deliverydate. In other table having vechile service details with columns servicedate and vechileno. I need to display the % of vichiles those are serviced in 0-15 months, 15-30months, 30-45 months so on, after the delivery date.

Something like this -

year           0-15         15-30      30-45

2016          65%            80%        70%             

Thanks in advance.   

[v-piga-msft]

Hi @Anonymous ,

The suggestion of claytun should be helpful.

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample so that we could have a test on it and help further on it.

Best  Regards,

Cherry

[Anonymous · Accepted solution]

I believe the article below may be of assistance.

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning