Date column

Question

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

)

greg_deckler · Answer

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

sshiny · Answer

Greg_Deckler&nbsp;I dont have that option&nbsp;&nbsp;

sshiny · Answer

amitchandak&nbsp;Can you please help with this?&nbsp;

anonymous · Answer

Hi&nbsp;sshiny&nbsp;,
&nbsp;
Here:

change the data format to Short Date:

Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;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.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;How to provide sample data

greg_deckler · Answer

sshiny&nbsp;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))
)

Forum Discussion

Date column

6 Replies

Related content

Find Most Recent Date Relative to another Date Column in Power Query

Progressive Date Columns

Generate a column for dates between start dates (list/ pivot?)

Power BI Date Column Issue

Creating a date column