ADDCOLUMNMS

Question

Hi all,&nbsp;I have these Calculated Table DAX formulasTrendMeasures1 =ADDCOLUMNS('RMBTrendData1',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "RMB Amount", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(Detail[Reimb. Amount]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL(Calendar), DATESINPERIOD(Calendar[Date],VALUES('First Date'[First Date])-1,-7,DAY)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;))RMBTrendData1 is a table with one row and one column (Trend Point)Result: TrendMeasures1 is a table with one row and two columns(Trend Point and RMB Amount)&nbsp;TrendMeasures2 =ADDCOLUMNS('RMBTrendData2',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "RMB Amount", &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(Detail[Reimb. Amount]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL(Calendar), DATESINPERIOD(Calendar[Date],VALUES('First Date'[First Date])-1,-14,DAY)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;RMBTrendData2 is a table with one row and one column (Trend Point)Result: TrendMeasures2 is a table with one row and two columns(RMB Amount and Trend Point)&nbsp;Because the Order of TrendMeasure1 and TrendMeasure2 are different, a Calculated Table that union the results of these measures produce undesirable result.Trend = UNION(TrendMeasures1,TrendMeasures2)Undesired Result:TrendPoint&nbsp; RMB Amount1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $14,000$15,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;Desired Result:TrendPoint&nbsp;&nbsp; RMB Amount1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $14,0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $15,000

stevecampbell · Accepted Answer

Could you try:&nbsp;Trend = 
UNION(
SUMMARIZECOLUMNS(TrendMeasures1[Trend Point],(TrendMeasures1[RMB Amount])
,
SUMMARIZECOLUMNS(TrendMeasures2[Trend Point],(TrendMeasures2[RMB Amount])
)&nbsp;Love hearing about Power BI tips, jobs and news?I love to share about these - connect with me!Stay up to date on&nbsp;&nbsp;Read my blogs on&nbsp;&nbsp;Remember to spread knowledge in the community when you can!&nbsp;&nbsp;

Forum Discussion

ADDCOLUMNMS

2 Replies