Create DAX index between 2 dates in a date table

Hi everyone, I need some help with the creation of an index between 2 dates. I've created an automatic date table using the Calendarauto() function and I'd like to create an index in a calculated...

DAX

index

RANKX

Greg_Deckler

3 years ago

eliottbbedard Try this:

Index 1 = 
VAR StartDate = DATE(2019,06,06)
VAR EndDate = DATE(2019,08,29)
Return
IF(
    'Date'[Date] >= StartDate
    && 'Date'[Date] <= EndDate,
    ( [Date] - StartDate ) * 1.,
    BLANK()
)

Forum Discussion

Create DAX index between 2 dates in a date table

Related content

Creating Index within Index

Creating Index base 100 charts

Multiple conditions Index

Create conditional index column

create index with measure