Forum Discussion

lavdeep's avatar
lavdeep
Advocate I
7 years ago
Solved

when i mark date column mark as date table showing error in other column

Hi,

when i mark date column mark as date table showing error in other columns

  • Hi lavdeep 

     

    The .[Date], .[Quarter] etc options are not available when you mark the table as date table. Power BI creates hidden structures to provide access to .[Date], etc. When you mark a table as date table, you are signalling you will create your own date structures and therefore those hidden ones are removed.

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion

    Hi lavdeep 

     

    The .[Date], .[Quarter] etc options are not available when you mark the table as date table. Power BI creates hidden structures to provide access to .[Date], etc. When you mark a table as date table, you are signalling you will create your own date structures and therefore those hidden ones are removed.