Forum Discussion
Variant Data type Greyed out
Hi,
I have a measure which I'd like to output in H:mm in my table, but the data type says variant and its greyed out.
The option on Date time is also just 4 dots. Does anybody know a reason that would cause this?
Its currently displaying the measure as a date dd/mm/yyyy in my table.
I know I can do FORMAT on top of the measure but I was wondering if it was possible to have the actual time?
Thanks
Liam
2 Replies
Anonymous , first of all, is detected as the date. for UK format there is setup required
Also, change data type to datetime or time an see if works. If not then go to Edit query/Data Transformation and try to change there.
Hi, Anonymous
Has the problem been solved so far? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
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.
