Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
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 ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
94 | |
89 | |
35 | |
32 |
User | Count |
---|---|
153 | |
101 | |
82 | |
63 | |
52 |