Forum Discussion
Summarize data between dates
Unfortunatly I don't really understand the Excel version of the formula. I am developing Power Query training now but it wont be ready for a couple of months. I have a couple of sample videos on my site here http://xbi.com.au/pqt and the second one may give you an idea of how to do it. It is a lot easier than Excel as you don't need to know any formulas - just use the menu options.
Tecnically you can import from a pivot table (as currently rendered on a screen) but I don't recommend it. Get the data loaded correctly into Power BI first and then everything is easy. I suggest the file format should be 1 row per month per user with the correct hours for that month.
If you post a workbook (link to Dropbox for example) with some sample real sample data and you clearly explain what the correct split between months is, I will see if I can create a demo for you.
Matt