topic Re: Group Range of Date and Return a Label in DAX Commands and Tips

Group Range of Date and Return a Label

aglpr — Sun, 05 Mar 2023 09:05:33 GMT

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 — Sun, 05 Mar 2023 09:22:54 GMT

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 — Sun, 05 Mar 2023 09:28:41 GMT

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 — Sun, 05 Mar 2023 09:46:07 GMT

Then it should be hard coded like

SWITCH (

TRUE ( ),

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

etc.

)

aglpr — Sun, 05 Mar 2023 09:56:34 GMT

Many thanks Tamer! It works now 🙂