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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MS3
Frequent Visitor

ADD A COLUMN WITH A SPECIFIC DATE

 

Hello!

 

Very stupid question. Seems super simple, but cannot find the solution. Just trying to add a date manually into a column in a table. All I need to add is a column with a specific date (e.g. 31/Dec/2019) which will have the same value in all the column.

 

I try adding a custom column but it does not recognize the DATE function, neither does it recognize a simple =DD.MM.YYYY

 

Thanks!

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

In DAX,

 

DATE(2019,12,31)

 

In Power Query, I would just do something like:

 

="12/31/2019"

 

And then just convert the column to be a date.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
MS3
Frequent Visitor

 

Many thanks! Works perfectly!

MS3

Great! Glad to hear it!


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

In DAX,

 

DATE(2019,12,31)

 

In Power Query, I would just do something like:

 

="12/31/2019"

 

And then just convert the column to be a date.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

It works, thank you for your help 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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