Forum Discussion
Date Table with weekday Table
i have created date table and want to find the sum of planned visits during selected date Date Table Visits by WeekDay Date WeekDay visitday planned_visits 4/1/2018...
Try the following
a) Set a relationship between the Weekday of Date Table and VisitDay of VisitsPlanned table.
b) Set the relationship to Many to 1 and Crossfilter direction both
c) Create a measure PlannedVistits= SUM([planned_Visits])
d) Create a slicer for Date from DateTable
e) Create a table visual with values as - Date from Date Table, Weekday from DateTable and measure [PlannedVisits]
f) You should get your result.
g) you could also show the [PlannedVisits] as a card visual.
Sample Screen Shot
If it works for you please accpet it as solution and also give KUDOS.
Cheers
CheenuSing