Forum Discussion

Hashiru's avatar
Hashiru
Icon for Helper I rankHelper I
7 years ago
Solved

ADDCOLUMNMS

Hi all,   I have these Calculated Table DAX formulas TrendMeasures1 = ADDCOLUMNS('RMBTrendData1',             "RMB Amount",              CALCULATE(                  SUM(Detail[Reimb. Amount]...
  • SteveCampbell's avatar
    SteveCampbell
    7 years ago

    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! 

     

SteveCampbell's avatar
SteveCampbell
Icon for Memorable Member rankMemorable Member
7 years ago

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's avatar
    Hashiru
    Icon for Helper I rankHelper I
    7 years ago

    Thanks SteveCampbell