Custom Table in Power BI

[shahidmahmood]

I have written measures  for Daily , MTD  & YTD data of acutal and budgeted of sales , production, collection and stock.

Now i want to present the data in the following tabular form.

[shahidmahmood]

I already have data like above . now i want to see them in a single table like below.

[Anonymous · Accepted solution]

Hi @shahidmahmood ,

I create three tables as you mentioned.

Sales table: 

Production table:

Collection table:

Then you can go to Power Query and choose to use Append.

Next you can create an index column and a Custom Column.

feeName = {"Sales", "Production", "Collection"}{[Index]}

Finally you can get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

pls provide some sample data and expected output

[shahidmahmood]

I already have data like above . now i want to see them in a single table like below.

[Kedar_Pande]

1. Insert a Matrix Visual
2. Sales Amount, Sales Numbers, Production, Collection, and Stock under the "Rows" field
3. Create the measures for all the columns and add on rows: Daily, MTD Actual, MTD Budget, YTD Actual, YTD Budget.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,

Kedar Pande

www.linkedin.com/in/kedar-pande