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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors