cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eckhardt_david
Regular Visitor

Combine data from different rows in 1 row with measure

Hi all,

 

I need to build a report where data from below table are combined into 1 row.

I have no access to the datamodel so it has to be done via a measure.

 

The below table is showing the data as is, filtered on the 3 transactions for LODNUM 354200224066522111.

 

Eckhardt_david_1-1631802707059.png

 

I have to combine this data with below requirements to get 1 row per LODNUM and DateValue.

 

Requirements:

get SHIP_ID where ACTCOD = INVCRE
get FRSTOL where OPRCOD = UTR
get TOSTOL where ACTCOD = FL_XFR and OPRCOD = UID

 

Desired result:

DateValueLODNUMSHIP_IDFRSTOLTOSTOLM_TRNQTY
14/09/202135420022406652211101851702582A-RCVL-202A-18-190-40450

 

Used tables and fields:

 

TableField
08-D_INTERNAL_PER_INPUTFRSTOL
08-D_INTERNAL_PER_INPUTLODNUM
08-D_INTERNAL_PER_INPUTOPRCOD
08-D_INTERNAL_PER_INPUTSHIP_ID
08-D_INTERNAL_PER_INPUTTOSTOL
08-C_INTERNAL_PER_INPUTDateValue
08-F_INTERNAL_PER_INPUTM_TRNQTY

 

Your help is much appreciated!

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You will need to create three measures, one for each of the values that you want to achieve.  Then you remove all columns from your visual that prevent grouping ( everything except datevalue,Lodnum,m_trnqty)  and add the measures instead.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

You will need to create three measures, one for each of the values that you want to achieve.  Then you remove all columns from your visual that prevent grouping ( everything except datevalue,Lodnum,m_trnqty)  and add the measures instead.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors