Forum Discussion
Return column name if data matches another column data in same row (or MIN value- select column)
Hi,
I am not sure when you are getting this error, however I have added a row with all the Date 1 - Date 5 as blank and modified the 2nd measure a little to show the value:Min_Date_Col =VAR _x = ""VAR _dt1 =IF([Min_Date] = VALUES(Earliest_Date[Date 1 ]), "Date1, ")VAR _dt2 =IF([Min_Date] = VALUES(Earliest_Date[Date 2 ]), "Date2, ")VAR _dt3 =IF([Min_Date] = VALUES(Earliest_Date[Date 3 ]), "Date3, ")VAR _dt4 =IF([Min_Date] = VALUES(Earliest_Date[Date 4 ]), "Date4, ")VAR _dt5 =IF([Min_Date] = VALUES(Earliest_Date[Date 5 ]), "Date5, ")VAR _returnText =_dt1 & _dt2 & _dt3 & _dt4 & _dt5RETURNIF(ISBLANK([Min_Date]),"",LEFT(_returnText,LEN(_returnText)-2))If this resolves your problem, then please accept this as solution, Thanks!
Thank you so much for writing everything out! May I ask if you know how to fix the error "A table of multiple values was supplied where a single value was expected." please? I do have a few rows where there is no date listed in any columns.
Hi,
I am not sure when you are getting this error, however I have added a row with all the Date 1 - Date 5 as blank and modified the 2nd measure a little to show the value:
If this resolves your problem, then please accept this as solution, Thanks!
Hello, thank you for the update! I did a few treaks on your DAX and it came out beautifully! much appreciated samratpbi!