In() function

[Rahul_Sanghavi]

Hi,

What is incorrect in the following statement since it is not giving the desired results.

in("PettyCash",Logged_User[DeleteTables])

Logger_user is a slice of current user logged in.

[DeleteTables] contains following list.

Users , MainMenu , PettyCash , SupplierMaster , ItemCategory , ItemMaster , PurchaseRequest , SupplierItemMaster

The result of the formula should return TRUE but it returns FALSE.

Please advise.

[Aurelien · Accepted solution]

Hi @Rahul_Sanghavi 

If I assume correctly, the expression [DeleteTable] is an enumList. So, the expression

Logged_User[DeleteTables]

Will give a list of Enumlist. The IN() expression won't work with this, as EnumList is basically a chain of character and interpreted as such first.

Can you try:

IN("PettyCash",
  SPLIT(CONCATENATE(Logged_User[DeleteTables])," , ")
)

[Rahul_Sanghavi]

Perfect Solution. Thanks.