Trying to calculate timestamp

[Sonyat810]

[v-jianboli-msft]

Hi @Sonyat810 ,

It looks like you are encountering an error in Power BI related to a calculation error in a measure called 'Master'[Based DATEDIFF]. The error message suggests that there is a comparison operation being performed between a text value and a date value, which is not supported in DAX.

To resolve this issue, you may need to review the DAX formula for the 'Master'[Based DATEDIFF] measure and ensure that all comparisons are being made between values of the same type. You may also want to check that the data types of the columns being used in the calculation are correct.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.