Forum Discussion

Sadr_Hoda's avatar
Sadr_Hoda
Frequent Visitor
3 years ago

Merge measure table

Hi,

 

I have prepared forecasted revenue and cost of sale table based on measures.

 

Now i want to merge two table.

 

Please advsie.

 

Thanks in advance.

Need Help

2 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    3 years ago

    Hi Sadr_Hoda 

     

    Can you post sample data as text and expected output?
    Not enough information to go on;

    please see this post regarding How to Get Your Question Answered Quickly:
    https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    The most important parts are:
    1. Sample data as text, use the table tool in the editing bar
    2. Expected output from sample data
    3. Explanation in words of how to get from 1. to 2.
    4. Relation between your tables

    Appreciate your Kudos!!
    LinkedIn:www.linkedin.com/in/vahid-dm/

    • Sadr_Hoda's avatar
      Sadr_Hoda
      Frequent Visitor
      3 years ago

      I want to prepare P&L account base on these two table ( which i created on measures). I am trying to merge two tables, however, column containing measure are not reflecting in merge table.  also advise me any other way to prepare forecasted P&L ( assuming each line of item has his own assumption)