Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

How to Get Your Question Answered Quickly

Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
Rakesk13's avatar
Rakesk13
Helper III
3 months ago

Hi team,

i have two different table with two different age bucket like 

Table 1: 

Age       ID

0-5        10

5-10      20

60-90    5

 

Table 2: 

Age       ID

0-5        30

5-10      60

11-20    70

 

OUTPUT:

 

Age       ID

0-5        40

5-10      80

11-20    70

60-90    5

 

looking for this type of output,please can you help on this, really appreciated for quick help.

 

Thanks & Regards,

Rakesh Jadhav

Tummalapati_95's avatar
Tummalapati_95
Frequent Visitor
3 months ago

Hi Rakesh,

 

If the above question is for power bi then use the below dax for the calculated table:

CombinedTable = 
SUMMARIZE (
    UNION ( 
        SELECTCOLUMNS(Table1, "Age", Table1[Age], "ID", Table1[ID]),
        SELECTCOLUMNS(Table2, "Age", Table2[Age], "ID", Table2[ID])
    ),
    [Age],
    "Total ID", SUMX(CURRENTGROUP(), [ID])
)

I hope this helps.

 

Thanks,

Praveen