Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
You may refer to the following post.
You may refer to the following post.
Please see this post. It has similar requirment.
thanks for the reply @Zubair_Muhammad.
But it seem not working on mine. Is there any other easier way to do that?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |