Trial Balance to P&L in Power BI.

We can easily prepare a P&L by simply establishing connection with the trial balance.
It requires some data transformation, modeling and DAX measures to present numbers in an easy to understand format.

[@hafiz786nasir]

You did a great job in a very very simplest way
Bravo! Keep shining

[@davidjames3494]

Very Good. I can understand that your language was a challenge for you but you did a good job. Congrats

[@chosen6616]

How to create a mapping table to map another table like you did in this video!

[@subhashinishanmugam1261]

Can you also show how to present the same data hierarchial please? Thank you!

[@cmaonlinetraining]

Great !! Anyway that we can calculate gross Profit , Operating Profit Net Profit etc ?

[@noushadaboobakar6492]

It possible to elaborate income statements? ,

[@moteaema598]

Mashaa Allah Good job Mr , Sayed
can you provide data sheet to achive the goal
appreciate your support .

[@xordigital7782]

So good , where can i get xl file?

[@user-no6kn4sh8h]

why multiply by -1 in the measure

[@asitmohanty7376]

Sir can you suggest me which institute provide us to power bi financials practical training about income statement, balance sheet etc.

[@syedalimahmood8464]

I would check and let you know.

[@imranbuhary]

The P&L is not complete with sub totals - Gross Profit, Operating Profit, Profit Before Tax etc.
Lets see if you have a great idea on how to get those in.

[@wilfredsithole1988]

Check enterprise dna - financial reporting with power bi

[@akilabuddika6023]

Sir, Can u please data set

[@syedalimahmood8464]

I made this video during the time of lockdown, and after that I got busy with my official commitments. I will search for the dataset and share definitely.

[@noushadaboobakar6492]

Bro , would you please give data set file

[@syedalimahmood8464]

I would check and revert.