Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
ankitpatira
Community Champion
Community Champion

@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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.