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" ) )
Zubair_Muhammad
Community Champion
Community ChampionHI Anonymous
Try this
Basically I am converting Date to Text Format by adding a " " at the end of formula
Estimated Delivery Date New =
VAR estimated_delivery_Date =
IF ( baseline_iv[est_deliv_dt] < TODAY (), TODAY (), baseline_iv[est_deliv_dt] )
RETURN
IF (
estimated_delivery_Date = BLANK (),
"Data Unavailabe",
estimated_delivery_Date & ""
)
Hi Zubari,
This isnt working sadly.
Can you suggest something else.
Just FYI : I can have multiple dates for one location type so im using latest date there.
- Zubair_Muhammad
Anonymous
Could you copy paste some data with expected results?
Let me know if you are not able to access this link
- Zubair_Muhammad
Anonymous
In the Excel file, could you add a column for expected result?