Add separate column to create statement

Krishna1992 · ‎01-28-2019

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 · ‎01-29-2019

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Krishna1992 · ‎01-29-2019

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