cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yorrick
New Member

Sample billing overview datasets.

Hello There,

 

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.

 

Thanks in advance,

Yorrick Mentink

1 REPLY 1
Highlighted
ankitpatira Community Champion
Community Champion

Re: Sample billing overview datasets.

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

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors