cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hylosko
Helper III
Helper III

transforming date values in column

Hello Experts !

 

i have 3 tables with 3 diffrent date values in date column, i want to get for every table ( im creating fact table from those 3) month date format (Y-M) and that is enough for me, how i can do that ?

 

hylosko_0-1655968692965.png1

hylosko_1-1655968737406.png2

hylosko_2-1655968758643.png3

 

 

 

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

(Replace Date Field appropriately)

For Table 2 and 3, use following formula

= Date.ToText(Date.From([Date Field]),"yyyy-MMM")

For Table1

= Date.ToText(Date.From(Text.From([Date Field])&"01"),"yyyy-MMM")

View solution in original post

1 REPLY 1
Vijay_A_Verma
Super User
Super User

(Replace Date Field appropriately)

For Table 2 and 3, use following formula

= Date.ToText(Date.From([Date Field]),"yyyy-MMM")

For Table1

= Date.ToText(Date.From(Text.From([Date Field])&"01"),"yyyy-MMM")

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors