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 ...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 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))
)