DAX -Evaluate each week ending date and find the earliest "open" order date for that week ending date.

TwinJohnson

New Member
Joined
Jul 15, 2021
Messages
11
Office Version
  1. 365
  2. 2011
Platform
  1. Windows
I have a date table that contains all dates and week ending. The raw data contains all order information. I'm able to identify the earliest open order date using the formula below. The formula below should be looking at each week ending date from my date table and identify if the order was open (date of initial review is blank) and if it's blank, find the oldest order date from the entire raw order data table (not just the week ending). I'm unsure how to write the DAX formula to show this. Thank you

Table names: Date Table [week ending], Log [Order Date] , Log [Date of Initial Review]

FIRST DATE= CALCULATE(
min('Log'[Order Date]),
FILTER(
ALL(' Log'),
ISBLANK('Log'[Date of Initial Review])
)
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,224,832
Messages
6,181,231
Members
453,026
Latest member
cknader

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top