Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
Busy | 14 Oct 2024 - 30 Nov 2024 | 50 |
Non Busy | 2 Dec 2024 - 12 Jan 2025 | 45 |
Busy | 13 Jan 2025 – 4 May 2025 | 55 |
Non Busy | 5 May 2025 – 27 Jun 2025 | 45 |
I am using below measure to create a colum so if i select that date range , all the dates in that range will come using slicer.
If i use below formula , i am not getting the date range for 2 Dec - 12 Jan as i see blank values.
Solved! Go to Solution.
@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.
@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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
8 |