Evaluate data from multiple rows to create a new value

[gcongrove]

Hello.

I have a table with the following layout:

Provision basis	User installed	Install everywhere
2	0	0
0	0	0
1	0	0
1	1	0

I need to evaluate these 3 rows and depending on the value of each create a new row such as this:

Provision basis	User installed	Install everywhere	New Column
2	0	0	Wont display
0	0	0	SCCM Install
1	0	0	SCCM Approval required
1	1	0	Manual install

I'm still learning DAX and havent quite figured out how to check multiple rows.

Thank you

[gcongrove · Accepted solution]

I was able to figure it out on my own:

TestColumn =

SWITCH (

    TRUE (),

    a_win10CTV_overview[ProvisioningBasis] = "2" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","Wont Display",

    a_win10CTV_overview[ProvisioningBasis] = "0" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","SCCM Install",

    a_win10CTV_overview[ProvisioningBasis] = "1" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","SCCM Approval required",

    a_win10CTV_overview[ProvisioningBasis] = "1" && a_win10CTV_overview[UserInstalled] = "1" && a_win10CTV_overview[InstallEverywhere] = "0","Manual Install"

)