Forum Discussion

sboobar's avatar
sboobar
Frequent Visitor
3 years ago
Solved

First Production Date across Category

I am trying to find the date that first production of any kind (green>0 or red>0) occurred for an item and to assign that date across the category item #. Below is a sample set of my data and a colum...
"DAX" "Earliest date"
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi sboobar 

    try like:

    Column =
    MINX(
        FILTER(
            TableName,
            TableName[Item]= EARLIER(TableName[Item] )
              &&TableName[Green]<>0
             &&TableName[Red]<>0
        ),
        TableName[Date]
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi sboobar 

try like:

Column =
MINX(
    FILTER(
        TableName,
        TableName[Item]= EARLIER(TableName[Item] )
          &&TableName[Green]<>0
         &&TableName[Red]<>0
    ),
    TableName[Date]
)