Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I am getting this error : Cannot convert value '' of type text to type Date. for this formula:
_Rev. Rec. Term in Days =
DATEDIFF ( [_Rev. Rec. Start Date], [_Rev. Rec. End Date], DAY )
Where:
_Rev. Rec. Start Date =
FORMAT (
DATEVALUE ( MIN ( 'Transaction Lines'[Rev. Rec. Start Date] ) ),
"mm/dd/yyyy"
)
and
_Rev. Rec. End Date =
FORMAT (
DATEVALUE ( MIN ( 'Transaction Lines'[Rev. Rec. End Date] ) ),
"mm/dd/yyyy"
)
Rev. Rec. Start Date and Rev. Rec. End Date are of Date Datatype.
I tried this:
_Rev. Rec. Term in Days =
IF (
ISBLANK ( DATEDIFF ( [_Rev. Rec. Start Date], [_Rev. Rec. End Date], DAY ) ),
BLANK (),
DATEDIFF ( [_Rev. Rec. Start Date], [_Rev. Rec. End Date], DAY )
)and this:
_Rev. Rec. Term in Days =
IF (
ISBLANK ( DATEDIFF ( [_Rev. Rec. Start Date], [_Rev. Rec. End Date], DAY ) ),
0,
DATEDIFF ( [_Rev. Rec. Start Date], [_Rev. Rec. End Date], DAY )
)
But still get the same error.
TIA,
Learner
Is this a calculated column or a measure?
DATEDIFF requires dates and when you add FORMAT you force it to a Text value, so start there.
All the _(underscore ones) are measures:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
103 | |
86 |