cancel
Showing results for
Did you mean:
Helper I

Hi all,

I have these Calculated Table DAX formulas

TrendMeasures1 =
"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 =
"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

1 ACCEPTED SOLUTION
Memorable Member

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!

Remember to spread knowledge in the community when you can!

Did I answer your question? Mark my post as a solution! Proud to be a Super User!

Connect with me!
Stay up to date on
Read my blogs on

2 REPLIES 2
Memorable Member

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!

Remember to spread knowledge in the community when you can!

Did I answer your question? Mark my post as a solution! Proud to be a Super User!

Connect with me!
Stay up to date on
Read my blogs on

Helper I

Thanks SteveCampbell

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### Claim Your Badge & Digital Swag!

Check out how to claim yours today!

#### Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors