Forum Discussion
Join values to single row
Hello everyone
I would like to know if in power BI there is any function or how I should do so that of these 3 columns I only leave the first one with the values of the other 2
I need the values in row 2 and 3 to stay in row 1
THANKS¡¡¡
Try a calculated table:
ADDCOLUMNS (
SUMMARIZE (
TableName[NUM ID],TableName[Type]
),"Col1", CALCULATE ( SUM ( TableName[1] ) ),
"Col2", CALCULATE ( SUM ( TableName[2] )),
"Col1+2", CALCULATE ( SUM ( TableName[1+2] ))
)
Alternatively you could use group by in power query.
4 Replies
Try a calculated table:
ADDCOLUMNS (
SUMMARIZE (
TableName[NUM ID],TableName[Type]
),"Col1", CALCULATE ( SUM ( TableName[1] ) ),
"Col2", CALCULATE ( SUM ( TableName[2] )),
"Col1+2", CALCULATE ( SUM ( TableName[1+2] ))
)
Alternatively you could use group by in power query.
Everything works perfectly for me, thank you very much :)), but in the column of 1 + 2, the value of the sum brings me wrong, you have any idea why it should be?
Hi PVVBl00
first you to have a unique date or index column. If don't you need to create an index column using power query. Then for the 3rd column the code would be
1 + 2 = VAR CurrentIndex = Date[Index] VAR CurrentTable = CALCULATETABLE ( Data, ALLEXCEPT ( Date, Data[NUM ID], Data[TYPE] ) ) VAR FirstIndex = MINX ( CurrentTable, Data[Index] ) VAR TotalValue = SUMX ( CurrentTable, Data[1] + Data[2] ) RETURN IF ( CurrentIndex = FirstIndex, TotalValue, 0 )Hi,
Show clearly the result you are expecting. Share data in a format that can be pasted in an MS Excel file.
