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
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)