Forum Discussion
Joining Tables
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 report...
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
Text please, I hate typing.
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 Just filter the blanks from your First Proof Date measure. See attached, Page 5.