Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Getting day name using calender table created using Dax

I created small Calender table using below.  Calendar = CALENDAR(DATE(2021,5,1),DATE(2021,05,14))   Then created a new measure for day name of the week using below ; Day of Week Name = FORMAT(...
Show and Tell
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    You should add as a new column not a measure to your calendar table: 

    Create a new column in your column in your calendar table with 

    Day of Week Name = FORMAT('Calendar'[Date],"dddd")

    Then, create a relationship between the Calendar[Date] and Daily Click Data table

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

You should add as a new column not a measure to your calendar table: 

Create a new column in your column in your calendar table with 

Day of Week Name = FORMAT('Calendar'[Date],"dddd")

Then, create a relationship between the Calendar[Date] and Daily Click Data table