Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I have table such as below:
Start Date | Date 1 | Date 2 | Date 3 | Date 4 | Date 5 | (DAX new column) Earliest Date |
1/1/20 | 1/3/23 | 1/3/23 | 1/3/23 | |||
5/5/20 | 9/9/23 | 5/20/24 | 9/9/23 |
with many more rows.
Please note (DAX new column) Earliest Date only looks at Date 1 - Date 5 columns (Start Date don't count).
How can I return the column name (Date 1 - Date 5), that contains value in (DAX new column) Earliest Date?
Please note some may return multiple column name.
Goal:
Start Date | Date 1 | Date 2 | Date 3 | Date 4 | Date 5 | (DAX new column) Earliest Date | (DAX new column) Earliest Date Column |
1/1/20 | 1/3/23 | 1/3/23 | 1/3/23 | Date 3, Date 4 | |||
5/5/20 | 9/9/23 | 5/20/24 | 9/9/23 | Date 2 |
Thank you so much!
Solved! Go to Solution.
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!
Hi,
considering you have 5 columns to compare, you can create below mentioned measures to achieve your goal.
First measure to find min date:
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!
You need to unpivot your data to bring it into a usable format. After that the measures will write themselves.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
64 | |
52 | |
49 |
User | Count |
---|---|
217 | |
89 | |
76 | |
66 | |
60 |