Forum Discussion
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 ...
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))
)