Extracting last 2 digits from a whole number column which is a date_key column

[Chandramouli_BI]

I have a date_key column which is in the format of 20230401, 20230402,...... 2023 is year, 04 is month & 01,02 ..are days. Tha data type of the date_key column is whole number. I want a new column in my table which consists of only days 01,02,...30/31. How to do? 

[LarryFisherman · Accepted solution]

Hi,

In Power Query you can create a new column with the days extacted from your original column.

In Power Query go to Transform -> Extract -> Last characters

If you want it in DAX instead, you can also use the LEFT function to get the same result.