Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
19 | |
14 | |
14 | |
13 | |
13 |