Forum Discussion
Solved
Calendar functions
Hi , I have Date column in table in the format '2007-07-20 16:38:36.763' , now I am trying to create calendar in Power BI. I have used Master Calendar = CALENDAR(Date(year(MIN('orderhash'[dateadd...
You can do both way but with DAX it would be somethig like:
DateOnly = DATE( Year(Table[DateAdded]), Month(Table[DateAdded]), Day(Table[DateAdded[) )
Change the data type to date in modelling tab and then set relationship onthis column with your "master data" date column.
You can do both way but with DAX it would be somethig like:
DateOnly = DATE( Year(Table[DateAdded]), Month(Table[DateAdded]), Day(Table[DateAdded[) )
Change the data type to date in modelling tab and then set relationship onthis column with your "master data" date column.
parry2k Ok, I am on modelling tabe and create new tabel is that right ?
there is new column option when you click on home tab in the menu. make sure your correct table is selected in right pane before adding new column
Thank you ,it is working. you are a star.