Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to get Q1-2020 ?

Hi All

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

 

Paul

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You can try like

     

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , You can try like

     

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

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

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

     

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