Date column

[sshiny]

I am using a date column whose format is mm/dd/yyyy in the model file. But, when I use the column in a measure(as a value inside a datacard) it brings time along with date. Please let me know how to show the date only.

Measure used in the data card -

Missing/Disputed Missing Since =

SWITCH (

TRUE (),

ISFILTERED('Tag Usage Fact'[Tag ID]),CONCATENATE("Missing/Disputed Since - ",SELECTEDVALUE('Loaner Consign Fact'[Missing Since]))

)

[sshiny]

@amitchandak Can you please help with this?

[Greg_Deckler]

@sshiny Select the measure in the desktop and in the Measure Tools tab, change the display format to short date.

[sshiny]

@Greg_Deckler I dont have that option 

[Greg_Deckler]

@sshiny If all else fails, try this:

Missing/Disputed Missing Since =
VAR __DateTime = TRUNC(SELECTEDVALUE('Loaner Consign Fact'[Missing Since]))
  SWITCH (
    TRUE (),
    ISFILTERED('Tag Usage Fact'[Tag ID]),CONCATENATE("Missing/Disputed Since " 
    ,DATE(YEAR(__DateTime), MONTH(__DateTime), DAY(__DateTime))
)

[Anonymous]

Hi @sshiny ,

Here:

change the data format to Short Date:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

Hello @sshiny ,

any updates?

Best Regards,
Gao
Community Support Team