Forum Discussion
How to search for particular GL Code ?
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.
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
4 Replies
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
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
Thank you for wanted to help me on my post.
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
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
