TwinJohnson
New Member
- Joined
- Jul 15, 2021
- Messages
- 11
- Office Version
- 365
- 2011
- Platform
- 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])
)
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])
)