Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago
Solved

Date Column Query

Hi,   I've had to create a new Date Dimension table in my data model and was wondering why the Date column has a different icon associated with it compared to the original table? Is the new one ok ...
Need Help
Show and Tell
  • ArchStanton's avatar
    ArchStanton
    3 years ago

    Hi,

     

    Thanks for your reply, I've just found what the issue is in the following post:

     

    https://community.powerbi.com/t5/Desktop/Switching-the-quot-Date-quot-field-to-an-identity-field/td-p/2900836

     

    I've unmarked my Date Dimension Table so its no longer a Date Table and the formatting has gone completely from the Date Field but I now have this in my 'Dates' column, which is based on the Date column:

     

     

    Dates = DATEVALUE('Date2'[Date])

     

     

    I'm just hoping there won't be any issue not have a designated Date table now!

     

    ps the Icon was classed an Identity Field icon

     

     

     

     

     

     

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    3 years ago

    Hi,

     

    Thanks for your reply, I've just found what the issue is in the following post:

     

    https://community.powerbi.com/t5/Desktop/Switching-the-quot-Date-quot-field-to-an-identity-field/td-p/2900836

     

    I've unmarked my Date Dimension Table so its no longer a Date Table and the formatting has gone completely from the Date Field but I now have this in my 'Dates' column, which is based on the Date column:

     

     

    Dates = DATEVALUE('Date2'[Date])

     

     

    I'm just hoping there won't be any issue not have a designated Date table now!

     

    ps the Icon was classed an Identity Field icon