ADDCOLUMNMS

[Hashiru]

Hi all,

I have these Calculated Table DAX formulas

TrendMeasures1 =
ADDCOLUMNS('RMBTrendData1',
            "RMB Amount",

             CALCULATE(

                 SUM(Detail[Reimb. Amount]),

       ALL(Calendar), DATESINPERIOD(Calendar[Date],VALUES('First Date'[First Date])-1,-7,DAY)

            )

)

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)

TrendMeasures2 =

ADDCOLUMNS('RMBTrendData2',
            "RMB Amount",

             CALCULATE(

                 SUM(Detail[Reimb. Amount]),

       ALL(Calendar), DATESINPERIOD(Calendar[Date],VALUES('First Date'[First Date])-1,-14,DAY)

            )

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)

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  RMB Amount

1                            $14,000

$15,000              2

Desired Result:

TrendPoint   RMB Amount

1                              $14,000

2                              $15,000

[SteveCampbell · Accepted solution]

Could you try:

Trend = 
UNION(
SUMMARIZECOLUMNS(TrendMeasures1[Trend Point],(TrendMeasures1[RMB Amount])
,
SUMMARIZECOLUMNS(TrendMeasures2[Trend Point],(TrendMeasures2[RMB Amount])
)

Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!

Stay up to date on  
Read my blogs on  

Remember to spread knowledge in the community when you can! 

[Hashiru]

Thanks SteveCampbell