Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a switch statement where in
SWITCH(TRUE, Transaction = "CREDIT" && Transaction Code = "693" && Receipt which has more than 6 characters)
Transaction | Transaction Code | Receipt |
CREDIT | 693 | 19100000000000 |
CREDIT | 534 | 17341 |
CREDIT | 534 | 17341 |
CREDIT | 534 | 12001 |
CREDIT | 534 | 17341 |
DEBIT | 534 | 12001 |
DEBIT | 534 | 17341 |
DEBIT | 534 | 17341 |
DEBIT | 534 | 17341 |
CREDIT | 534 | 12001 |
CREDIT | 534 | 17341 |
CREDIT | 534 | 17341 |
DEBIT | 534 | 17341 |
DEBIT | 534 | 17341 |
DEBIT | 534 | 17341 |
DEBIT | 534 | 17341 |
DEBIT | 534 | 17341 |
DEBIT | 534 | 2411558071 |
DEBIT | 534 | 17341 |
Either you posted before you wanted to or there's not enough detail in this question.
What are you wanting to do?
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
How do I filter the Receipt column for 6 character lengths or more
Based on what you've told me, drop this measure into your table...
Filter6 =
SWITCH (
TRUE (),
MIN ( Filter6[Transaction] ) = "CREDIT"
&& MIN ( Filter6[Transaction Code] ) = "693"
&& LEN (
MIN ( Filter6[Receipt] )
) > 5, 1
)
All very dependent of what your end result needs to be.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.