Forum Discussion
Expression that yield variant data type error cannot be used to defined calculated columns
Hi, * Im new to power bi and moving from tableau backgroud. I have a calculation, desribing that in words(nested if) if date_col is not null then if(date_col) < today then display tod...
Anonymous
You can use this MEASURE
Please see attached file
Measure = VAR result = MIN ( 'handle blanks'[Estimated Delivery Date] ) RETURN IF ( ISBLANK ( result ), "Data Unavailable", FORMAT ( result, "Short date" ) )
Hi Zubair,
I have added the expected result in pbix file where i have written the calculation as well in algorithmic form.
if you could see blanks in the pbix files for dates, those have to be replaced with 'data unavailable'
Anonymous
You can use this MEASURE
Please see attached file
Measure =
VAR result =
MIN ( 'handle blanks'[Estimated Delivery Date] )
RETURN
IF ( ISBLANK ( result ), "Data Unavailable", FORMAT ( result, "Short date" ) )
Its hard to type cast in powerbi. Thanku so much. I appreciate it
Hi Zubair,
I have another issue on the same view at
Could you please suggest somthing there?