Forum Discussion
Custom Table in Power BI
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.
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.
5 Replies
- Insert a Matrix Visual
- Sales Amount, Sales Numbers, Production, Collection, and Stock under the "Rows" field
- 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
pls provide some sample data and expected output
I already have data like above . now i want to see them in a single table like below.
I already have data like above . now i want to see them in a single table like below.
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.
