Predicted usage by Month into a Matrix visual

Question

Hi,&nbsp;I am trying to create a visual that predicts usage of a product over period of time in the future.&nbsp;I have current value of usage, calculated average monthly usage, date of last reading for usage and number of months since last reading. I have tried to write a DAX that will predict usage for each month. I haven't been able to get this right yet.&nbsp;Bascially&nbsp;x=current usagey= average monthly usage&nbsp;I need to calculate x + y for every month until x reaches a certain value.&nbsp;Preferrably results will go into a matrix and/or gantt chart visual. With a date column along the top and the predicted usage displayed for each month &amp; year for each serial number.

lbendlin · Answer

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

kristyp · Answer

https://docs.google.com/spreadsheets/d/1tdHU0dCmzz_8tf-fhhC3xObYJPvYT4dy/edit?usp=drive_link&amp;ouid=107327280152538851278&amp;rtpof=true&amp;sd=true&nbsp;Please see link.

Forum Discussion

Predicted usage by Month into a Matrix visual

2 Replies

Related content

Matrix Visual Duality

Custom Matrix Visual

Power Matrix visual

Formatting Matrix Visuals

Matrix visual