Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Sonyat810
Helper I
Helper I

How to add a onth to the table

I have a table with the days but it doesn;t show the month. How can I create a column that shows the Month & day?

1 ACCEPTED SOLUTION

pls try this

Month = IFERROR (FORMAT( DATE(2023,8, VALUE ( 'CE Lookup 2'[Day] )),"MMMM"), BLANK ( ) )

View solution in original post

6 REPLIES 6
Idrissshatila
Super User
Super User

hello @Sonyat810 , 

 

can you show me what type of date you have ?

 

if you have something like 1/1/2023 for example, to have the month in a seperate column

 

calculated column = format ('Tablename' [datecolumn], "mmmm")

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




This all I have as far as day, but no month. It won't let me change it to date format, so I will have to create something.

 

Sonyat810_0-1696937983960.png

 

Hello @Sonyat810 ,

 

but how would you know this day falls under which month ? this won't work like that.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




I want this to say "August". How do I write that? This is what I have:

Month = IFERROR ( VALUE ( 'CE Lookup 2'[Day] ), BLANK ( ) )
Sonyat810_0-1696941093863.png

 

 

pls try this

Month = IFERROR (FORMAT( DATE(2023,8, VALUE ( 'CE Lookup 2'[Day] )),"MMMM"), BLANK ( ) )

All of the days are for August.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.