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 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
6 Replies
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.
Create a measure that include CALCULATE and FILTER function to return table (row) with only Id=FirstProofMessageId values.
