Forum Discussion

eliottbbedard's avatar
eliottbbedard
Frequent Visitor
3 years ago
Solved

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's avatar
    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()
)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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()
)