Spreading data over time

[richard-powerbi]

Let's say I have a table with 3 columns:

Hours, StartDate, EndDate

If I want to show a graph with on the X dates and on the Y hours, how can I spread hours over time?

For example:

400, 2019-01-01, 2019-01-29

Graph with X on weekly basis should look like:

100, 100, 100, 100

Are there visuals that can do this? Or do I have to create seperate rows for every date in the data model devided by the amount of days? It would add tons of rows for every existing row. I hope there is a better solution...

[Greg_Deckler · Accepted solution]

I did something very similar to this once and put it in the Quick Measures gallery as Hours Breakdown.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Hour-Breakdown/m-p/625085#M306

You could potentially do it as a measure but might also have luck creating a DAX table, just depends. DAX and Power BI are really built and optimized to summarize raw data, not invent data from summarized data. You're kind of going about it backwards.

[Ferrol40]

There are number of forms you can check out may be they might help also i have posted a similar question and waiting for replies

Forums that might help 

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community

Spread value across time between 2 dates - Microsoft Power BI Community

Solved: Re: Spread duration across month - Microsoft Power BI Community

My Question

Spread Hours across days and link to date table to... - Microsoft Power BI Community