Forum Discussion
butterscotch
Helper II
Helper IICombine 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.
Ahmedx
Super User
Super Userand try this
Start date = FORMAT( DATEVALUE("01/"&'Table'[Month]&"/"&'Table'[Year]),"MMM-YY")
butterscotchHelper II
Helper IIThank you