Forum Discussion
How to exclude specific data through Formula
Hello All,
I am working on Power BI Dashboard and struck at one point. I have huge size data with multiple fields. In one of the tables, I am trying to show the Order count. The problem I am struggling, there are certain orders that start from 1,2,3 (like 101,212,320) and the length is more than 7 . I need to exclude those only. Please help me with how I can exclude it.
Some other point:
Normal Order number Max length - 7
Order Starts from 1 (101,112,124) length more than 7
Thanks,
Gabriel_Walkman it solved. I have created the formula.
9 Replies
Hi!
there are certain orders that start from 1,2,3 (like 101,212,320)
What is an order in this case? Do you mean an order id? Is your example a list of three numbers, or one long number that you just added commas to? Is your example in text format or number format?
Try making a custom column with Text.Length( Text.From( [orderColumn] )), then just filter that column to be <=7.Gabriel_Walkman Thank you for your reply. Please see the attached example for more details.
This is the sample list of all order number types. I just wanted to exclude a long type of Order number from the list (see the top 6-7 orders starts from 101, 103, 121, 215, 315). Please let me know how I create any new measure for an order number or any modification to the existing field.
order Numbers
10152020002
10152020003
10152020038
11152020001
12152020007
12152020013
2152020227
2152020297
3152020272
3152020272
5541831
5541831
5541831
20895
20895
20895
4503160
4503160
5541830
7502350
7502350
CON2007-65328
CON2007-65328
CON2007-65328
Q-44852
Q-44852
Q-44852
"Please let me know how I create any new measure for an order number or any modification to the existing field."
I'm sorry, but this is extremely basic stuff, so I'll have to recommend googling. I'd do this in power query by creating a new custom column.