Add separate column to create statement

[Krishna1992]

Hi Everyone,

I am trying to implement income statement like below,

I have KPI data with actuals, and so. But I don't know how to create a category of account type to aggreagate the mesaures.

I am new new to Power BI, and please help me with this.

Thanks

[v-piga-msft]

Hi @Krishna1992,

---

I have KPI data with actuals, and so. But I don't know how to create a category of account type to aggreagate the mesaures.

---

I have a little confused about your requirement "create a category of account type to aggreagate the mesaures". 

From my understand, the data in the image is your data sample?

If it is, could you share your desired output so that I can understand your requirement better and get the solution quickly?

Best Regards,

Cherry

[Krishna1992]

Hi @v-piga-msft,

The data is not same given in the figure.

I have KPI data like revenue which is a measure etc.

But I dont know how to create the category/dimension in the acount type column.

Eg. Where can I create a column whether by using seperate table or query editor or creating a column, which step can I take to create a dimension of rows like rev, accounts rcvbl, expenses, etc.

Thanks