Hi gurus, I am not sure if WebI let the scenario be real on the tool, I am in need ot creating a measure or dimension for the below mentioned case.
Beg Date Criteria
1-if Beg End Date is empty for each Prod Order Trans of one particular Prod Order then Beg Date is Created On
2-If one specific order has more than two Prod Order and Beginning and End dates are not null then Beginning date of the subsecutive line
Please refer the picture attached.
I wonder If BO is capable of doing this achieve.