Forum Discussion

Mayank09's avatar
Mayank09
Frequent Visitor
5 years ago
Solved

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 stru...
Need Help
Gabriel_Walkman's avatar
Gabriel_Walkman
Continued Contributor
5 years ago

What should happen to CON2007-65328 or Q-44852? The first is >7 characters long.

Mayank09's avatar
Mayank09
Frequent Visitor
5 years ago

Gabriel_Walkman Basically, In my data there is two types of orders :

 

1. Long Order number 10152020002, 2152020227, etc. (Offline added Orders)

2.  CON2007-65328, Q-44852, 7502350, 20895, 5541831, etc. (system generated Orders)

 

So i just need to delete these Offline added orders only and keep all system-generated order in my data 

Thanks,

  • Mayank09's avatar
    Mayank09
    Frequent Visitor
    5 years ago

    Gabriel_Walkman it solved. I have created the formula. 

    • Gabriel_Walkman's avatar
      Gabriel_Walkman
      Continued Contributor
      5 years ago

      Great! Please mark your own post as a solution.

    • v-yingjl's avatar
      v-yingjl
      Community Support
      5 years ago

      Hi Mayank09 ,

      Glad to hear the issue is solved. You can kindly share your solution and accept it as solution, that way, other community members could easily find the answer when they get same issues.

       

      Best Regards,
      Community Support Team _ Yingjie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.