Forum Discussion
Shamatix
Post Partisan
Post PartisanMeasure Cross tables
Hey fellow power bi users, I currently have 2 tables, table A and table B, table A has a column with TRUE and FALSE values, in table B i want to create a measure that points towards table As c...
ShamatixPost Partisan
Post PartisanYes but I cant create a conditional column in Table B based on a column in Table A as far as I know (It only shows the column in the table you are creating the conditional column in)
GilbertQ
Super User
Super UserThat is correct, as far as I currently know that is a limitation in Power BI.
What you could do after you create it in the one table, is in the Data Model you could create a Calculated Column there and as long as you have your relationships you could then use the RELATED function to bring it into your second table.
- Shamatix
Well with Related I can only go over to my "IKEY" table, as mentioned I have a many to many relationship so I needed a relationship table in order to create a relationship between the two.