Help with new colomn and DAX formula

[Dmoetnogleren]

Hello,

I have two tables, one DIM table with different peopleID's , one FACT table with  people ID's and diploma's. I want to create two new columns in the DIM table. One with 'has got diploma A' (true/false) and one with 'has got diploma B" (true/false). Can anyone suggest how to do this? I think this is not difficult for anyone with PBI experience, but I have just started. 

PeopleID

1

2

3

PeopleID	Diploma
1	A
1	B
3	A

[xifeng_L · Accepted solution]

Hi @Dmoetnogleren ,

You can try below calculated column expression.

has got diploma A = CALCULATE("A" IN VALUES('Fact'[Diploma]))

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[Dmoetnogleren]

Thank you, this is a good solution!