Forum Discussion
Saxon10
Post Prodigy
Post ProdigyLookup by filter by column (New calculated column req)
I have a two tables are data and report. In data table contain item and id no. Each item contain two different id number one is 200 and 300. In report table item contain unique value. If ...
Hi Saxon10 ，
According to you description，you could create columns as follows:
RESULT Id No 200 = VAR _a = SUMMARIZE ( FILTER ( 'DATA', [Id No] = 200 ), [Item] ) RETURN IF ( [Item] IN _a, "TRUE", "FLASE" )RESULT Id No 300 = VAR _a = SUMMARIZE ( FILTER ( 'DATA', [Id No] = 300 ), [Item] ) RETURN IF ( [Item] IN _a, "TRUE", "FLASE" )Another request:
RESULT1 Id No 200 = VAR _new = SUMMARIZE ( FILTER ( 'DATA', [Id No] = 200 ), [Item] ) RETURN IF ( [Item] IN _new, 200 )RESULT1 Id No 300 = VAR _new = SUMMARIZE ( FILTER ( 'DATA', [Id No] = 300 ), [Item] ) RETURN IF ( [Item] IN _new, 300 )In addition, when [item]=123, Because [Id No] does not contain (200/300), so it may be “False” ?
IF so ,The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserSaxon10 , if this 200 and 300 in columns then you have to unpivot the table
https://radacad.com/pivot-and-unpivot-with-power-bi
Then you have to create a column like this in both tables and join
key = [Item]& " " & [Id No]
Saxon10Post Prodigy
Post ProdigyThanks for the reply. Is there any option in order to achieve my final output.