Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago

Date Dimension Field Icon

Hi,

I've just created a new Date Dimension table in a copied version of an old report. 

Why is the Date Icon different in my new report? The old report has a mini calendar to the left of DATE

 

Old Report:

 

 

New Report:

Here I have a different icon to the left of DATE?

 

Why is this happening and is this something that will cause me issues?

 

Lastly, I have a Start of Year and a End of Year column which can no longer reference the Date column (see error message below).

 

 

I can fix this by editing it to this:

 

End Of Year = ENDOFYEAR('Date2'[Date],"3/31")

 

 

This automatically generates a Date Hierarchy:

 

I'm worried my Date Dimension table isn't behaving properly and could cause me problems?

Thanks,

Thanks

 

No RepliesBe the first to reply