Forum Discussion

BekahLoSurdo's avatar
BekahLoSurdo
Icon for Resolver IV rankResolver IV
6 years ago
Solved

Default Date Hierarchy

Good Morning, I have two identical date tables that were created via DAX as a variation (some columns commented out, fiscal year defined but not many other changes) of Marco's code found here: https...
Need Help
  • AmanBedwal's avatar
    AmanBedwal
    6 years ago

    BekahLoSurdo  the difference is Table 1 Date field is Marked as Date Table hence you see this behavior. To make Table 1 Date column identical to Table 2 Date column simply uncheck Mark as Date Table.

     

     

    Did I answer your question? Mark my post as a solution.

     

    Regards

    Aman Bedwal

AmanBedwal's avatar
AmanBedwal
Frequent Visitor
6 years ago

BekahLoSurdo  the difference is Table 1 Date field is Marked as Date Table hence you see this behavior. To make Table 1 Date column identical to Table 2 Date column simply uncheck Mark as Date Table.

 

 

Did I answer your question? Mark my post as a solution.

 

Regards

Aman Bedwal

BekahLoSurdo's avatar
BekahLoSurdo
Icon for Resolver IV rankResolver IV
6 years ago

Hi AmanBedwal,

 

Thank you! I see it now. In the absence of an explicitly marked "Date Table," Power BI is making it's own default date hierarchy. When a Date Table is created, that is unneeded. 

 

My original question stemmed from the fact that I could get a Forecast line with Table 2 but not with Table 1... I do want to use my Date Table (I need a FY) but now I have a better idea of things to try. If I can't get it I will open a new post for that.

 

Thanks again!