Find original order date & total order amount

[Orstenpowers]

Dear all,

I do need your help.

Attached one example: Order: 010251070

This order consists of 20 different order positions, from 10 to 190.

Following parameters are in use:

'IObOL new (incl K Group)'[Order No]

'IObOL new (incl K Group)'[Order_no_&_pos]

'IObOL new (incl K Group)'[Date]

'IObOL new (incl K Group)'[Amount EUR]

Column “Date” illustrates the date when an order position has been adjusted, we call it “Transaction date”.

The oldest date in column “Date” shows the date of order placement…could also be previous month or year.

What I need is the following:

• an additional column that shows the original order date (for the attached example it should show 18.03.2021) in each row
• I will need this to evaluate the order entry by order date
• an additional column that shows the total order value (for the attached example it should show 8.993€) in each row
• I will need this to filter “complete” orders by total order amount

I have no idea how to manage this. Maybe it is not necessary to do it with additional columns?

Hopefully one of you can help me…

[Orstenpowers]

Sorry, I forgot to attach...

[amitchandak]

@Orstenpowers , Somehow, I do not see any sample data

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Orstenpowers]

@amitchandak 

Now a real sample file...

https://1drv.ms/u/s!An1U2xHUY9WxhsAByKXVQu2YqhhilQ?e=c1et0h