Forum Discussion
Functions and Parameters in Add Custom Column
Hi All, Um not aware of DAX and want to create custom columns in query editor. non of the functions are working in the expression except control flow statements (IF) or any arithmetic operators(...
can u please help me out with this...??
how can i write following in M query cus its not suppose to take in operator there:
if [AccountNumber] in ("1","2",""......"n") and another condition
then ([Rate] * [Revenue] )
else 0
apart from giving one condition for every account number with OR operato.
do we have any equivalance for 'IN' operator in Power Query..???
To compare a value against a list of values, use the List.ContainsAny function. This function actually compares two lists, but for your purposes just think of each row of the column as a list that only contains a single item.
if List.Contains( {[AccountNumber]}, {1, 2, 3} ) and [OtherColumn] = "other condition" then ([Rate] * [Revenue]) else 0