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" ) )
Anonymous
Could you copy paste some data with expected results?
Let me know if you are not able to access this link
Anonymous
In the Excel file, could you add a column for expected result?
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" ) )