Power Pivot

[Sri81]

Hi,
I am trying to write a nested if condition in power pivot query tab such as

If Month = Jan, feb, Mar, Apr and If Dealer = "ABC, XYZ, DEF then Sales rep = "N12"

Should I keep writing If condition to match above multiple criteria or if there is a simple way saying

if month in (jan, FEB, Mar) and Dealer in (ABC, XYZ, DEF) then Sales rep = "N12"

 

[Matt Allington]

Is thi power pivot or power query? If power pivot, where exactly are you trying to write this?

 

[Sri81]

Power pivot on the data sheet.

 

[Matt Allington]

Are you writing a calculated column or a measure? I assume a calc column but it is not clear. Can you set is in your source data? if not, you could consider loading with Power Query and creating the column there, or simply keep writing the nested if.