Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with 3 Columns (date datatype) and I need to create new column, which will give me minimum of these 3 column (smallest date)
I can use if else for 2 comparing columns, Is there is a function which i can used to compare the dates with more than 2 columns instead of if-else .
ex -
Col A - 10/1/2020
Col B - 7/1/2020
Col C - 8/1/2020
Result column - 7/1/2020
Thanks in Advance,
Shubham
Solved! Go to Solution.
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
@shubhamamilkant , not very clear
you have if else or Switch , Switch True()
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |