Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Field icon for date fields

Hi,   I have two fields with dates in. One shows a date icon and the other (a calculated field) does not:   With date icon:   Without date icon:   eventhough in the toolbar the da...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Anonymous 

       icon means  that this is  a calendar date field with a built-in date table.

    And not all calculated fields show the "fx" icon .

    If  a field is  a Calculated column with a non-numeric data type ,it will show this icon .

    If a field is a  Numeric calculated column with a Data Analysis Expressions (DAX) formula that defines the column’s values ,it will show this icon .

     

    it is true that the data maybe recognized as "text " rather than "date" due to the format problem, so sometimes you need to manually create formulas to convert the data.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

   icon means  that this is  a calendar date field with a built-in date table.

And not all calculated fields show the "fx" icon .

If  a field is  a Calculated column with a non-numeric data type ,it will show this icon .

If a field is a  Numeric calculated column with a Data Analysis Expressions (DAX) formula that defines the column’s values ,it will show this icon .

 

it is true that the data maybe recognized as "text " rather than "date" due to the format problem, so sometimes you need to manually create formulas to convert the data.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.