Forum Discussion

fmigg's avatar
fmigg
New Member
7 years ago
Solved

Creating a table based on another table Column Value

Hi guys!  I'm new on Power BI and DAX, such in this community :manhappy: Currently I have a dataset with the following structure: Table 1 In which Revenues column collect the correct revenu...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi fmigg,

    Based on my test, you could refer to below steps:

    Create a calculated column in your row table:

    filtered value = IF([Phase]=CALCULATE(MAX('Table1'[Phase]),FILTER('Table1','Table1'[Column]=EARLIER(Table1[Column]))),[Revenue],0)

    Create a new table:

    New Table = SUMMARIZE('Table1','Table1'[Column],'Table1'[ID],"A",CALCULATE(SUM('Table1'[filtered value])))

    Result:

     

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi fmigg,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

siemdevlieger's avatar
siemdevlieger
Helper I
7 years ago

Hi, 

 

I am trying to do the same. Where can I add a new table based on another table?

Looking at the PBIX it was not done in the query editor right?

 

Struggling with this, hope someone can give an easy explanation here.

 

Thanks in advance!

 

Regards,

Siem