Skip to Content
0
Nov 23 at 01:06 PM

To find Min date or First order date

81 Views

I have a vendors who has ordered multiple times , i want to find the first order date for both the vendors in WEBI .I am using the formula =Min ([V_Date] ForEach ([Order Date])) In([Planning Group]) but the results are not consistent for all the vendors .

Note : i created a dimension V_date : =ToDate([Order Date];"mm/dd/yy")

Planning group : Customer name

Eg:

Vendor 1 : ABC

Order date (mm/dd/yy): 1/10/19

3/07/20

2/10/22

Op Booking Qtr : 19Q4

20Q1

22Q1

Vendor 2 : XYZ

Order date (mm/dd/yy): 1/10/18

3/07/19

2/10/21

Op Booking Qtr : 18Q4

19Q1

21Q1