Forum Discussion

MadhuReddy's avatar
MadhuReddy
Helper I
8 years ago
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...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    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.

MadhuReddy's avatar
MadhuReddy
Helper I
8 years ago

parry2k Hi, Do i have to add it in modelling tab or query editor ?  What will be the script for calculated column..Could you please guide me. Thank you for your time.

parry2k's avatar
parry2k
Super User
8 years ago

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.

  • MadhuReddy's avatar
    MadhuReddy
    Helper I
    8 years ago

    parry2k Ok, I am on modelling tabe and create new tabel is that right ?

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    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

  • MadhuReddy's avatar
    MadhuReddy
    Helper I
    8 years ago

    Thank you ,it is working.  you are a star.