Forum Discussion

mirkoslav's avatar
mirkoslav
Frequent Visitor
7 years ago
Solved

How to make P&L - beginner

Hi,   I'm a little bit advanced begginer with Power BI (working with measures, time and similar) and need help how to make report like one on picture below. I need suggestions where to start and h...
Need Help
  • mirkoslav's avatar
    mirkoslav
    7 years ago

    I've found solution with post Create calculated row. But it is not working with custom sorted structure... new issue to solve. :-)

     

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi mirkoslav,

Based on my test, you could refer to below formula, but I suggest you to import your excel data to Power BI:

Sample data:

Create a calculated column(if you want to show all the formulas, you need to add more if conditions in this formula):

Formulas = IF('Table1'[Indeks]=1,CALCULATE(SUM(Table1[Total])),IF('Table1'[Indeks]=3,CALCULATE(SUM(Table1[Total]),FILTER('Table1','Table1'[Indeks]=5))/CALCULATE(SUM(Table1[Total]),FILTER('Table1','Table1'[Indeks]=2))))

Result:

You could also download the pbix file to have a view.

Or you could calculate all the data in excel and import to the Power BI:

Reference:https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

 

Regards,

Daniel He

    • mirkoslav's avatar
      mirkoslav
      Frequent Visitor
      7 years ago

      I've found solution with post Create calculated row. But it is not working with custom sorted structure... new issue to solve. :-)