cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

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

Accepted Solutions
Super User I

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!

2 REPLIES 2
Super User I

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!

Regular Visitor

Thanks SteveCampbell

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!