Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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
@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
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |