Joining Tables

[mpalha04]

Hello,

I have the following columns below, but I would only like to show the rows where Id=FirstProofMessageId. How do I go about doing this? These columns are from 2 seperate tables on my reports and are joined by the OrderId column. The "First Proof Date" is a calculated column with the formula below:

First Proof Date =
IF (
vProofMessage[Id] = RELATED ( vReviewOrderSLA[FirstProofMessageId] ),
vProofMessage[MessageSentTimeLocal]
)

Any help is appreciated!

 

Thanks

[gselvag]

Create a measure that include CALCULATE and FILTER function to return table (row) with only Id=FirstProofMessageId values. 

[Greg_Deckler]

Can you provide example data from the 2 tables so we know what columns are in each? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[mpalha04]

Thanks @Greg_Deckler, please see below.

vProofMessage:

vReviewOrderSLA:

[Greg_Deckler]

Text please, I hate typing.

[mpalha04]

Hi @Greg_Deckler,

Please see below:

vProofMessage: 

36977	14000	9/13/2018 14:13
36977	14942	9/18/2018 16:23
36977	14943	9/18/2018 16:23
36977	14944	9/18/2018 16:24
36977	14974	9/18/2018 18:33
36977	15159	9/19/2018 16:26
36978	14017	9/13/2018 15:13
36978	14075	9/13/2018 17:42
36978	14102	9/13/2018 19:25
36978	14480	9/16/2018 13:02
36978	14489	9/17/2018 2:31
36979	14027	9/13/2018 15:53

vReviewOrderSLA:

9/13/2018 12:21	36976	14006
9/13/2018 12:44	36977	14000
9/13/2018 13:03	36978	14017
9/13/2018 13:17	36979	14027
9/13/2018 13:38	36980	14063
9/13/2018 13:44	36981	14049
9/13/2018 13:50	36982	14025
9/13/2018 13:54	36983	14018
9/13/2018 14:04	36984	14739
9/13/2018 14:31	36985	14048
9/13/2018 14:48	36986	14041
9/13/2018 14:48	36987	14079

[Greg_Deckler]

Just filter the blanks from your First Proof Date measure. See attached, Page 5.