Forum Discussion

shahidmahmood's avatar
shahidmahmood
Frequent Visitor
1 year ago
Solved

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.  
Need Help
  • Anonymous's avatar
    Anonymous
    1 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.

shahidmahmood's avatar
shahidmahmood
Frequent Visitor
1 year ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 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.