Forum Discussion
Solved
Combine column
Hello everyone ! i have table and i have column with date data type , when i select the column to be inserted to my table, the column divided into 2 , year and month, how do i combine it to become...
Hii butterscotch
In a date column you used in visuals or tables, I will act as a hierarchy level in the below image (1. before).1. before
Select the table visual, and in the visualization pane, right-click the date column and change the hierarchy to the original date as shown in the below image.
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you.
or in power query
"01."&[Month]&"."& Text.From([Year])