how to get quarter name from Quarter offset

[Anonymous]

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

[talespin · Accepted solution]

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 - E...

[Anonymous · Accepted solution]

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

[talespin · Accepted solution]

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 - E...

[Anonymous]

@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

[Anonymous]

Hi Team,

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