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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Kunek
New Member

Add column with manually typed date

Hello,

I am looking for a solution to add new column in power query with a date I will type in manually (not current date).

That is, I need to add the step that will add column 'Date' in date format with the value of for example 30.11.2023 for every row. 

 

Any tips would be appreaciated 🌷

1 ACCEPTED SOLUTION
spinfuzer
Super User
Super User

Date.FromText("11.30.2023") or #date(2023,11,23)  if format is dd/mm/yyyy

View solution in original post

4 REPLIES 4
spinfuzer
Super User
Super User

Date.FromText("11.30.2023") or #date(2023,11,23)  if format is dd/mm/yyyy

Thank you, this is exactly what I was looking for!

PijushRoy
Super User
Super User

Hi @Kunek 

The requirement is not clear.
You can create a custom column and insert the date. But I have doubts whether all rows should be the same date or not.
Also always entering new dates in PQ is not the solution.

Please share screenshots, demo data, and more details about your query.

Thank you for the reply.

I am receiving each month a similar data sheet, only with different values. I need to prepare a report showing how the values change month by month, so I added each data sheet as separate data source, added the date manually to each of them and use append queries to get one query I can further work on.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors