Future Quarter Column from Fiscal Quarter

[nmbl]

Hi,

I have a Date table having Fiscal Quarter and Current Quarter fields.

Current Quarter = 'Date'[Fiscal Quarter]=year(now()-7/24)&"-Q"&ceiling(month(NOW()-7/24)/3,1)

has value as True and False

Looking to create a Future Quarter column, really appreciate any suggestions.

Thanks,

[v-mengzhu-msft]

Hi @nmbl ,

What data do you want your Future Quarter column to be based on and how do you go about calculating it to get it?

Please give me some sample data and the expected results.

Best regards,

Community Support Team Selina zhu

[nmbl]

As an example the Current Quarter is resulting as 2022 - Q4 and the Future Quarter should result as 2023 - Q5.

Based on the CQ logic, we are able to bring data for the current quarter and have been asked to bring the data for Future Quarter. As for Data stand point we have other tables but the Date Table is Dynamic which needs to have the new logic creation. 

Current Quarter = 'Date'[Fiscal Quarter]=year(now()-7/24)&"-Q"&ceiling(month(NOW()-7/24)/3,1)

has value as True and False

Thanks