I want to create another column using OR Logic between column 1, column 2
Table = Summary
column 1 = team,
column 2= shared team,
Purpose of that new table will be to use it for filtering, I want to see all the records in single column if col1 team or col2 shared teams..
If need more information please send an email at email@example.com
Go to Solution.
Hi @DavidGM ,
Create a new table like below:
Table 2 = DISTINCT(UNION(VALUES('Table'[Team]),VALUES('Table'[Shared Team])))
View solution in original post
Team Shared Team
So I like to show all the work assigned to team member using team column OR shared team coloumn
@DavidGM Sorry, having trouble following, can you post sample data as text and expected output?Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, 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/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!