Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

Column not recognised as a date

Hi, 

I have created a new column using the dax below, however, whilst this outputs the correct date, it's not recognised as a date so I can use this when trying to create other columns like between dates. 

 

The data type is a Date and formatted short hand but that doesn't change anything. 

 

Is there anything I can do to change this please? 

 

test[earliestdate] is a Column that has min(test[date]

 

Test = 

Minx(

Index ( 1,

Apps,

Orderby (apps[earliestdate], asc),

,

Partitionby (test[id]),

Matchby (test[id], test[cat], test[earliestdate])),

Test[earliestdate]) 

Need Help

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

    Hello M_SBS_6,

     

    A simplified version for each test[id], might look more like this:

    Earliest Date = 
CALCULATE(
    MIN(test[date]),
    ALLEXCEPT(test, test[id])
)

    Hope this helps.