Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Create a measure that include CALCULATE and FILTER function to return table (row) with only Id=FirstProofMessageId values.
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.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |