Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Merge Rows using DAX

Hello,    I'm wondering if someone can help in what I percieve to be a simple query,  I have a table which I have created in DAX using SELECT COLUMNS and CALCULATETABLE.      The result o...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

First GIndex has different values in all three columns.

Second, there should be aggregation function to group  function like Min, Max on all other columns

 

You can also try summarize. example

 

SUMMARIZE(
                data,
                data[ID],
				"max_date",
				MAX( 'Date'[Date]),
                "Max_Col", max(data[Col1])
            )

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak , 

     

    Thanks for the response, sorry the about the GIIndex column, it was only there for testing the correct information had pulled through.

     

    SUMMARIZE works perfectly! Thanks for explaining I'll be using this again. 

     

    Breaks (Next 3) = SUMMARIZE(
    'Subscription - Break',
    'Subscription - Break'[SBQQ__Contract__c],
    "M Break Date 1", MAX('Subscription - Break'[Break Date 1]),
    "M Min Notice 1", MAX('Subscription - Break'[Min. Notice 1]),
    "M Penalty 1", MAX('Subscription - Break'[Penalty 1]),
    "M Option 1", MAX('Subscription - Break'[Option 1]),
         "M Break Date 2", MAX('Subscription - Break'[Break Date 2]),
         "M Min Notice 2", MAX('Subscription - Break'[Min. Notice 2]),
         "M Penalty 2", MAX('Subscription - Break'[Penalty 2]),
         "M Option 2", MAX('Subscription - Break'[Option 2]),
             "M Break Date 3", MAX('Subscription - Break'[Break Date 3]),
             "M Min Notice 3", MAX('Subscription - Break'[Min. Notice 3]),
             "M Penalty 3", MAX('Subscription - Break'[Penalty 3]),
             "M Option 3", MAX('Subscription - Break'[Option 3])

     

    Regards

    Dobby Libr3