Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Merge two rows (having a different cell value) into a single row; overwrite values for text

Hello,   I want to merge rows when duplicate "Task" value is found; and overwrite text from one "Response" value to another cellwhen Scaled Value is "-1.00". For example, see below two rows: In...
DAX
Merge
Power Query
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

In fact, VahidDM 's answer is roughly correct. Just a little modification is needed. Please refer to the following.

 

 

Table 2 = 
FILTER(SUMMARIZE(
    'Table',
    'Table'[Ask],
    'Table'[Date],
    'Table'[Item],
    'Table'[No.],
    'Table'[Number],
    'Table'[User ID],
    "Response",
        CALCULATE(
            MAX( 'Table'[Reply] ),
            ALL( 'Table' ),
            'Table'[Value] = -1
        ),
    "Scale Value", MAX( 'Table'[Value] )
),[Scale Value]<>-1)

 

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.