Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.