Forum Discussion

sshiny's avatar
sshiny
Icon for Helper II rankHelper II
4 years ago

Date column

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]))
)

 

Need Help
Show and Tell

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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