Calculation to check if an entry is there for a particular category

[venus]

Hi All,

I am looking for a calcualtion for the below scenario. Can you please help.

Data

Account_Id, Program

1234, Program 1

1234, Program 2

1432, Program 1

1534, Program 3

The result should be a calculation for each of the programs which will just show a yes or no for that particular account. 

Acct,  Program 1, Program 2, Program 3

1234, Yes, Yes, No

1432, Yes, No, No

1534, No, No, Yes

1555, No, No, No

Thanks,

[CNENFRNL · Accepted solution]

A most straightforward solution is PQ,

let
    Source = SourceT,
    #"Added Index" = Table.AddIndexColumn(Source,"Index",1,1),
    #"Pivoted Column" = Table.Pivot(#"Added Index", List.Distinct(#"Added Index"[Program]), "Program", "Index", each if List.Count(_)>0 then "Yes" else "No")
in
    #"Pivoted Column"

DAX measure can do the trick, but an extra dimension is necessary,

[venus]

I used the pivot table approach for my issue. Thanks !!

[tamerj1]

Hi @venus 

New matrix, place the id on rows and program on columns. Then place this measure in the values

IF ( ISBLANK ( COUNTROWS ( TableName ) ), "False", "True" )

[CNENFRNL]

By your means, you'll get "True" cells but not even a single "False" due to auto-exist mechanism under the hood.