Solved: How to get Q1-2020 ?

Anonymous · ‎10-07-2020

Hi All

Can some one share with me Quarter field expression ? i need to get Q1-20 , Q2-20

Paul

amitchandak · ‎10-07-2020

@Anonymous , You can try like

New column = "Q" & Format([date],"Q-YY")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

amitchandak · ‎10-07-2020

@Anonymous , You can try like

New column = "Q" & Format([date],"Q-YY")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

mahoneypat · ‎10-07-2020

You can use this expression to add a Quarter column to your Date table.

Quarter = Format('Date'[Date], "\QQ-YY")

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

How to get Q1-2020 ?

Helpful resources

Power BI Monthly Update - November 2025

Fabric Data Days

FabCon Atlanta 2026

How to Get Your Question Answered Quickly

FabCon is coming to Atlanta