Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sequential Dates

Hello.    I am trying to assign numbers to dates, but not based on the 365 calendar. I need it to start on a certain date (9/18/2022 for example) as day 1, and sequentially count the days as number...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Don't filter out the weekends then (the < 6 part):

     

    Sequential Date Number = 
  VAR __StartDate = MAX('Table'[StartDate])
  VAR __Date = MAX('Table2'[Date])
  VAR __Table = CALENDAR(__StartDate, __Date),
RETURN
  COUNTROWS(FILTER(__Table))

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Sounds similar to Sequential. Sequential - Microsoft Power BI Community

Maybe something like:

Sequential Date Number = 
  VAR __StartDate = MAX('Table'[StartDate])
  VAR __Date = MAX('Table2'[Date])
  VAR __Table = 
    ADDCOLUMNS(
      CALENDAR(__StartDate, __Date),
      "__WeekDay",WEEKDAY([Date],2)
    )
RETURN
  COUNTROWS(FILTER(__Table,[__WeekDay]<6))

Mainly guessing, no sample data, etc.