cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NadeeshaE
Regular Visitor

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('Calendar'[Date],"dddd")
 
I have another data source with 'date' column .(source - Daily Click Data
 
Now simply i want to draw a bar grapg indicating the counts from daily click data source for different days names of the week (as in sunday how many counts , monday how mant , etc? ) 
But how can I join my calender table with the 'Daily Click Data ' source and draw this graph ?
 
1 ACCEPTED SOLUTION
Fowmy
Super User IV
Super User IV

@NadeeshaE 

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

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Fowmy
Super User IV
Super User IV

@NadeeshaE 

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

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Mohammad_Refaei
Solution Specialist
Solution Specialist

Day Of Week Name could be added as a column to your Calendar table which I assume has a relathionship to source - Daily Click Data table. In your chart use the day name from the Calendar table and aggregate the click values from the daily click data table.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors