to show new order

[CTan42]

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.

[v-chuncz-msft · Accepted solution]

@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...

[Zubair_Muhammad]

@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...

[CTan42]

thanks for the reply @Zubair_Muhammad.

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