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.
- Anonymous1 year ago
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
- Kedar_PandeSuper User
- 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
- ryan_mayuSuper User
pls provide some sample data and expected output
- shahidmahmoodFrequent Visitor
I already have data like above . now i want to see them in a single table like below.
- shahidmahmoodFrequent Visitor
I already have data like above . now i want to see them in a single table like below.
- AnonymousNot applicable
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.