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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!