Bridge table containing YearQuarter and Previous YearQuarter

[Some13lse]

Hi all,

I would like to create a bridge table consisting of a column with YearQuarter and a second column containing the same YearQuarter or the previous YearQuarter.

YearQuarter	SameAndPreviousYQ
2022Q4	2022Q3
2022Q4	2023Q4
2023Q1	2022Q4
2023Q1	2023Q1
...	....

[Anonymous · Accepted solution]

Hi @Some13lse ,

Please try to create table with below dax formula:

Table =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2023, 01, 01 ), DATE ( 2023, 10, 23 ) ),
    "Year Quarter",
        YEAR ( [Date] ) & "Q"
            & QUARTER ( [Date] ),
    "Previous Year Quarter",
        YEAR ( [Date] ) - 1 & "Q"
            & QUARTER ( [Date] )
)

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please don't.  Add these columns to your regular Calendar table instead.