Group Range of Date and Return a Label

[aglpr]

Hello colleague,

Sorry for this stupid-but-simple question

How do I group the date range using DAX and return a value label?

Example : Range date of 1 Jan 2023 to 31 Jan 2023 will be labeled "A". Range date of 1 Feb 23 to 28 Feb 23 will be labeled "B", etc

I already have the date table in my dataset btw.

Thank you!

[tamerj1]

Hi @aglpr 

you can create a calculated column the date table using switch statement 

SWITCH (

MONTH ( 'Date'[Date] ),

1, "A",

2, "B",

etc.

)

or perhaps you need to do that for Year-Month?

[aglpr]

Hello Tamer,

Many thanks for your reply. What if the date is specific? (not limited only to the month)

For example 3 Jan 23 to 16 Feb 23 is "A", 17 Feb 23 to 21 Mar 23 is "B"

Thanks again!

[tamerj1 · Accepted solution]

@aglpr 

Then it should be hard coded like

SWITCH (

TRUE ( ),

'Date'[Date] IN CALENDAR ( DATE ( 2023, 01, 03 ), DATE ( 2024, 01, 23 ) ), "A",

etc.

)

[aglpr]

Many thanks Tamer! It works now 🙂