Forum Discussion
Date Table Relationship wrong after adding a measure
I think I'm having trouble with my relationship between my date table and my staff detail. When I add Days & Snapshot Date to a table everything looks great but if I add a measure it adds a blank...
jdiruzza
When you create a dates table n Popwer BI it has to have the complete dates, partial dates will cause issues. Pleas modify your calendar table as follows and try:
My date table is created from the StaffDetail:
VAR _mindate = date( year(min('StaffDetail'[SnapshotDTS]) , 1 , 1)
VAR _maxdate = date( year(max('StaffDetail'[SnapshotDTS]) , 12 , 31)
RETURN
CALENDAR (_mindate, _maxdate)