your data should be pivoted around dates to create a dimension Pivot Data from Columns to Rows - Tableau
Leave the KPI out of the pivot and deal with it separately in the aggregation (min(), or avg()
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.