Forum Discussion

sshiny's avatar
sshiny
Helper II
3 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 ...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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

  • sshiny's avatar
    sshiny
    Helper II
    3 years ago

    Greg_Deckler I dont have that option 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hello sshiny ,

        any updates?

         

        Best Regards,
        Gao
        Community Support Team

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

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