Forum Discussion

Post Patron

6 years ago

Solved

Spreading data over time

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

Need Help

Greg_Deckler
6 years ago
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.

Greg_Deckler

Community Champion

6 years ago

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.