Forum Discussion
shahidmahmood
1 year agoFrequent Visitor
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.