For my own startup ive got a massive Excel file with all our billing information in there. This means, an endless ammount of rows with project names, dates followed by the amounts billable per month (thats right, one column for each month). However, i am having some trouble making this data useable in Power BI.
Im relatively new to the programme but am quite a quick learner when it comes to computers. I guess what i am really looking for is a sample billing overview for an organization (may be a hypothetical case file) but just to see how each kolom is organized so i can start to reorganize my own excel file!
In the end, my file should be able to provide a quick financial overview of my company.
@Yorrick I guess what you're asking for is sample financial report that you can use to build for your own organisation right ? Since you've mentioned that in your excel you have one column for each month I would suggest you to use Pivot feature in power bi desktop and convert all those columns into rows so you have atleast manageable dataset that you can use to do time based analysis. Check out this for some available sample reports in power bi service that may help you get what you want.