Power BI format question

[bthumble]

Hello, I am new to BI and have a couple of questions.

I have added two columns, month and quarter and need help with formatting. Would like the month to be displayed with two numbers. For example 1 would be 01, 2 would be 02, etc. Also the quarter column is displaying 1 and would like it to be displayed as 2024 Q1, 2024 Q2, etc.

Thanks

 

[RoryA]

How did you add the two columns?

 

[bthumble]

Both added columns are based on a column called posted date. Inserted a new column for each using add column and chose date, then chose

for month chose date then month
for quarter chose date then quarter then quarter of year.

 

[RoryA]

For the month column, the current formula will look something like:

= Table.AddColumn(#"Changed Type", "Month", each Date.Month([Posted date]), Int64.Type)

and you'll need to amend the end of the formula to:

each Date.ToText([Posted date],"MM"), type text)

and for the quarter step, it would end with

each Date.ToText([Posted date], "yyyy")&"Q"&Text.From(Date.QuarterOfYear([Posted date])), type text)

 

[bthumble]

Having issues with the date column. This is what I have
= Table.AddColumn(#"Changed Type", "Month", each Date.Month([Posting Date]), Int64.Type)each Date.ToText([Posted date],"MM"), type text)

getting this alert
Expression.SyntaxError: Token Eof expected.

Am I doing something wrong?

 

[RoryA]

You need to replace everything from the each in the original function with what I suggested, so:

= Table.AddColumn(#"Changed Type", "Month", each Date.ToText([Posting date],"MM"), type text)

 

[bthumble]

Started from scratrch. Highlighted the Posting Date column and then chose Add Column -- Date -- Month -- Month. This is the formula that shows up

= Table.AddColumn(#"Promoted Headers", "Month", each Date.Month([Posting Date]), Int64.Type)

Changed the formula to

= Table.AddColumn(#"Promoted Headers", "Month", each Date.ToText([Posting date],"MM"), type text)

Now the data in the column is showing Error.

 

[RoryA]

What is the data type of the Posting Date column in the previous step? It needs to be Date (not DateTime or any other type).

 

[bthumble]

It is date. Example of one of the dates in the column is below:

1/24/2024

 

[RoryA]

Is the actual column type date though? The fact that the value in it looks like a date doesn't mean the column type is date.

It might be best if you can post the entire M code from the Advanced editor.