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,

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