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.

parry2k's avatar
parry2k
Super User
8 years ago

You need to add another column in your data table to for date, you current dateadded column is date and time and the relatedionship with master date is not working because of the time

 

Add another calculated column for dateadded which is just date and then set relationship on this column with master date table.

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