Forum Discussion
Bring the same column with conditions
- 9 years ago
1) If you want this in a New Table (not a Table Visual)
click New Table on the Modeling Tab and type this
Summary Table = SUMMARIZECOLUMNS ( Devices[DeviceName], "First Owner", CALCULATE ( FIRSTNONBLANK ( Owners[OwnerName], 1 ), FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 1 ) ), "Second Owner", CALCULATE ( FIRSTNONBLANK ( Owners[OwnerName], 1 ), FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 2 ) ) )2) You can also achieve this without creating a New Table by creating these 2 Measures instead
First Owner = CALCULATE ( FIRSTNONBLANK ( Owners[OwnerName], 1 ), FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 1 ) )and
Second Owner = CALCULATE ( FIRSTNONBLANK ( Owners[OwnerName], 1 ), FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 2 )
)then click the Table Visual icon in the Visualizations area
add the DeviceName from the Devices Table and the 2 Measures
Hope this helps! :smileyhappy:
1) If you want this in a New Table (not a Table Visual)
click New Table on the Modeling Tab and type this
Summary Table =
SUMMARIZECOLUMNS (
Devices[DeviceName],
"First Owner", CALCULATE (
FIRSTNONBLANK ( Owners[OwnerName], 1 ),
FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 1 )
),
"Second Owner", CALCULATE (
FIRSTNONBLANK ( Owners[OwnerName], 1 ),
FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 2 )
)
)2) You can also achieve this without creating a New Table by creating these 2 Measures instead
First Owner =
CALCULATE (
FIRSTNONBLANK ( Owners[OwnerName], 1 ),
FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 1 )
)and
Second Owner =
CALCULATE (
FIRSTNONBLANK ( Owners[OwnerName], 1 ),
FILTER ( Device_Owner, Device_Owner[OwnerSeq] = 2 )
)then click the Table Visual icon in the Visualizations area
add the DeviceName from the Devices Table and the 2 Measures
Hope this helps! :smileyhappy:
- Anonymous9 years agoNot applicable
I can not thank you enough!
You helped me sooooooooooo much.
I really, really appreciate your time and attention.
You save my week.
:smileyvery-happy: