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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,223,322
Messages
6,171,446
Members
452,404
Latest member
vivek562

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