Forum Discussion

binayjethwa's avatar
binayjethwa
Helper V
2 years ago
Solved

Date Range calculation using Dax

Hi ,    I have a requirement to calculate date range using dax.   I need to create a date rage column for below dates.   SeasonDatesDenominator Non Busy 1 Jul 2024 - 13 Oct 2024 45 Bus...
Need Help
  • mark_endicott's avatar
    mark_endicott
    2 years ago

    binayjethwa - You can use this formula, just change the table name:

     

    var _Year = YEAR('Table'[Date 1])
return
    SWITCH(TRUE(),
    'Table'[Date 1]>=date(_year,12,2) && 'Table'[Date 1]<=date(_year+1,1,12),"2 Dec - 12 Jan",
    'Table'[Date 1]>=date(_year,1,3) && 'Table'[Date 1]<=date(_year,5,4),"13 Jan - 4 May",
    'Table'[Date 1]>=date(_year,5,5) && 'Table'[Date 1]<=date(_year,6,27),"5 May - 27 Jun",
    'Table'[Date 1]>=date(_year,7,1) && 'Table'[Date 1]<=date(_year,10,13),"1 Jul - 13 Oct",
    'Table'[Date 1]>=date(_year,10,14) && 'Table'[Date 1]<=date(_year,11,30),"14 Oct - 30 Nov",

 BLANK())

     

    Screenshot shows it works for me, if it works for you please mark it as the solution. 

mark_endicott's avatar
mark_endicott
Super User
2 years ago

binayjethwa - You can use this formula, just change the table name:

 

var _Year = YEAR('Table'[Date 1])
return
    SWITCH(TRUE(),
    'Table'[Date 1]>=date(_year,12,2) && 'Table'[Date 1]<=date(_year+1,1,12),"2 Dec - 12 Jan",
    'Table'[Date 1]>=date(_year,1,3) && 'Table'[Date 1]<=date(_year,5,4),"13 Jan - 4 May",
    'Table'[Date 1]>=date(_year,5,5) && 'Table'[Date 1]<=date(_year,6,27),"5 May - 27 Jun",
    'Table'[Date 1]>=date(_year,7,1) && 'Table'[Date 1]<=date(_year,10,13),"1 Jul - 13 Oct",
    'Table'[Date 1]>=date(_year,10,14) && 'Table'[Date 1]<=date(_year,11,30),"14 Oct - 30 Nov",

 BLANK())

 

Screenshot shows it works for me, if it works for you please mark it as the solution.