Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 ;). |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.