Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Eckhardt_david
Frequent 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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors