How to search for particular GL Code ?

[admin11]

Hi All

I have a long list of GL Code , in case i need to search for particular GL Code , it there a faster way ? instead now i need to manually search.

[DataVitalizer]

Hi @admin11 

Could you please display the output of that formula just to understand the need in order to suggest a solution ?

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated 

[admin11]

@DataVitalizer 

Thank you for wanted to help me on my post.

@selimovd 

have share with me how to create the expression , to create a expense summary table. display on the right side of the below image. it work fine :-

below is my PBI file :-

https://www.dropbox.com/s/qdvgujb4v2fu4ch/PBT_V2021_400%20GL_TI.pbix?dl=0

Paul

[DataVitalizer · Accepted solution]

Hi @admin11 ,

I agree with @amitchandak, you can use 

IF('GL'[GL Code] in {81651,80351,80612},1,0)

instead of

SWITCH(TRUE(), 'GL'[GL Code]=81651 || 'GL'[GL Code]=80351 || 'GL'[GL Code]=80612

Did it work ? Mark it as a solution to help spreading knowledge.

A kudos would be appreciated 

[amitchandak]

@admin11 , You can use in  [GL Code] in {81651,81351 } //add  , separated values

What is the objective here?

can Text filter help here  https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview