cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Migscruz
Helper I
Helper I

Convert day date into number

Hi!

 

I need help with this please:

 

I have a a column in a table that shows me the day/month/year. I would like to transform it into a number considering the day of the month:

 

Example:

DateNumber
26/11/202126
27/11/202127
28/11/202128
29/11/202129
30/11/202130
1/12/20211
2/12/20212
3/12/20213
4/12/20214

 

How can i do this? i've tried with left function but it doesn't work.

 

Thanks 🙂

1 ACCEPTED SOLUTION
rsbin
Impactful Individual
Impactful Individual

@Migscruz,

Try:

DayofMonth = Day[Date]

 

Regards,

View solution in original post

1 REPLY 1
rsbin
Impactful Individual
Impactful Individual

@Migscruz,

Try:

DayofMonth = Day[Date]

 

Regards,

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors