cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CTan42 Helper II
Helper II

to show new order

Hi mates,

 

I have 1 excel file about the sales order.

 

Month   Order No.     Order Type     

Jan         11111           New Order 

Jan         22222           New Order

Jan         33333           New Order

Feb        44444            New Order

Feb        11111            Existing Order

Feb        33333            Existing Order

 

I would like to using function/formula to create the Order Type column.

 

The idea is if the order no. appear in last month, then the order type is existing order / if the order no.dont appear in last month, then the order type is new order.

 

Is there any function to do that? Thanks a million for the help.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: to show new order

@CTan42,

 

You may refer to the following post.

http://community.powerbi.com/t5/Desktop/Comparing-a-month-to-it-s-relative-previous-month-in-a-table...

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

View solution in original post

3 REPLIES 3
Super User III
Super User III

Re: to show new order

@CTan42

 

Please see this post. It has similar requirment.

 

http://community.powerbi.com/t5/Desktop/Calculated-Column-for-New-Employee-amp-Left-Employee/m-p/454...

 

 

 

 

 

Try my new Power BI game Cross the River
CTan42 Helper II
Helper II

Re: to show new order

thanks for the reply @Zubair_Muhammad.

 

But it seem not working on mine. Is there any other easier way to do that?

Community Support
Community Support

Re: to show new order

@CTan42,

 

You may refer to the following post.

http://community.powerbi.com/t5/Desktop/Comparing-a-month-to-it-s-relative-previous-month-in-a-table...

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

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors