Forum Discussion

Qmars007's avatar
Qmars007
Frequent Visitor
4 years ago

Date format issue

Hi,  I hope some experts help me with a date format issue.  The format of my date column on the data source, an excel file, is Q1 20/21, Q2 20/21, Q3 20/21, Q4 20/21, Q1 21/22..... So when I import...
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Qmars007 ,

You cann't change the quarter to date format, as in all the date formats, there isn't one format for showing quarters.

For your calculate purpose, you can create a calculated column in the table contains date, like this:

Qtr =
"Q" & QUARTER ( [Date] ) & " "
    & FORMAT ( [Date], "YY" ) & "/"
    & FORMAT ( [Date], "YY" ) + 1

Then the quarter relates to date, and can also relates to the quarterly KPIs.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.