Evaluate data from multiple rows to create a new value

Question

Hello.I have a table with the following layout:Provision basisUser installedInstall everywhere&nbsp;&nbsp;&nbsp;&nbsp;200&nbsp;&nbsp;&nbsp;&nbsp;000&nbsp;&nbsp;&nbsp;&nbsp;100&nbsp;&nbsp;&nbsp;&nbsp;110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I need to evaluate these 3 rows and depending on the value of each create a new row such as this:Provision basis&nbsp;User installedInstall everywhere&nbsp;New Column200Wont display000SCCM Install100SCCM Approval required110Manual install&nbsp;&nbsp;I'm still learning DAX and havent quite figured out how to check multiple rows.Thank you

gcongrove · Accepted Answer

I was able to figure it out on my own:&nbsp;TestColumn =SWITCH (&nbsp;&nbsp;&nbsp; TRUE (),&nbsp;&nbsp;&nbsp; a_win10CTV_overview[ProvisioningBasis] = "2" &amp;&amp; a_win10CTV_overview[UserInstalled] = "0" &amp;&amp; a_win10CTV_overview[InstallEverywhere] = "0","Wont Display",&nbsp;&nbsp;&nbsp; a_win10CTV_overview[ProvisioningBasis] = "0" &amp;&amp; a_win10CTV_overview[UserInstalled] = "0" &amp;&amp; a_win10CTV_overview[InstallEverywhere] = "0","SCCM Install",&nbsp;&nbsp;&nbsp; a_win10CTV_overview[ProvisioningBasis] = "1" &amp;&amp; a_win10CTV_overview[UserInstalled] = "0" &amp;&amp; a_win10CTV_overview[InstallEverywhere] = "0","SCCM Approval required",&nbsp;&nbsp;&nbsp; a_win10CTV_overview[ProvisioningBasis] = "1" &amp;&amp; a_win10CTV_overview[UserInstalled] = "1" &amp;&amp; a_win10CTV_overview[InstallEverywhere] = "0","Manual Install")

Forum Discussion

Evaluate data from multiple rows to create a new value

1 Reply

Related content

Lazy evaluation

Creating multiple Audiences in PowerBI App

Cache Text.Split / List Select line for multiple evaluation

Evaluating Multiple fields to Calculate a Value

Multiple messages when new item created

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