topic how to get quarter name from Quarter offset in DAX Commands and Tips

how to get quarter name from Quarter offset

Anonymous — Mon, 22 Jan 2024 06:40:34 GMT

Hi Team,

Need some details from your end... when we try to add Quarter offset -1 then the quarters will show (Oct, Nov, Dec). so i need heading name will apper Q4, same way when we try to add -2 then heading name will show Q3 like that i want all 4 quarter names .

Kindly check and share the measure how we can make this. waiting for your response

thanks

Re: how to get quarter name from Quarter offset

talespin — Mon, 22 Jan 2024 07:10:42 GMT

Sorry I did not understand your question.

You can get Quarter using QUARTER and FORMAT functions "Q"&FORMAT('Date'[Date], "q").

If you are looking for something else, See if this post helps

DAX for adding offset columns - days, weeks, months, quarters and years - DAX / DAX Calculations - Enterprise DNA Forum

Re: how to get quarter name from Quarter offset

Anonymous — Tue, 23 Jan 2024 09:35:31 GMT

talespin ;-

Actually what iam looking for is below

if you see the above Quarter 4 2023 , Quarter 3 2023 those should be automatically need to change as like "Quarter 1: 2024 , Quarter 2: 2024, Quarter 3: 2024, Quarter 4: 2024". when we selected quarter offset, based on this if we select quarter -1 (oct nov dec) then Q4, Quarter -2 (July aug sep) then Q3 , Quarter -3 (Apr may jun) then Q2, Quarter -4(jan, feb , mar) then Q4

Like wise if we use Quarter offset 0 ( current quarter need come that is (jan 2024, feb 2024 mar 2024 ) then Q1 2024.

Kindly check and do the needful

thanks

Re: how to get quarter name from Quarter offset

Anonymous — Wed, 24 Jan 2024 10:43:11 GMT

Hi Team,

can you some one check and let us know update on the above needed an dax

Re: how to get quarter name from Quarter offset

Anonymous — Tue, 30 Jan 2024 09:15:12 GMT

Hi Anonymous ,

Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Create a measure

Quarter Name from Offset = VAR CurrentQuarterNumber = QUARTER(TODAY()) VAR AdjustedQuarterNumber = MOD((CurrentQuarterNumber + SELECTEDVALUE('Table'[QuarterOffset]) - 1),4) + 1 RETURN SWITCH( AdjustedQuarterNumber, 1, "Q1", 2, "Q2", 3, "Q3", 4, "Q4" )

Final output

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly