Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Im looking to identify the earliest date between the two colomns in the same row.
Example data
Input | Output | ||
First Start | Second Start | Date | |
15/03/2021 | 15/09/2022 | 15/03/2021 | |
17/03/2021 | 1/03/2021 | 1/03/2021 |
Solved! Go to Solution.
Hi @MdJ83 ,
Please have a try.
Create a column.
Column =
VAR first_date = 'Table'[First Start]
VAR second_date = 'Table'[Second Start]
RETURN
IF ( first_date > second_date, second_date, first_date )
Or a measure.
Measure =
VAR start_1 =
MAX ( 'Table'[First Start] )
VAR second_2 =
MAX ( 'Table'[Second Start] )
RETURN
IF ( start_1 > second_2, second_2, start_1 )
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MdJ83 ,
Please have a try.
Create a column.
Column =
VAR first_date = 'Table'[First Start]
VAR second_date = 'Table'[Second Start]
RETURN
IF ( first_date > second_date, second_date, first_date )
Or a measure.
Measure =
VAR start_1 =
MAX ( 'Table'[First Start] )
VAR second_2 =
MAX ( 'Table'[Second Start] )
RETURN
IF ( start_1 > second_2, second_2, start_1 )
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Please check the below picture and the attached pbix file.
it is for creating a new table.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks that worked and thanks for showing me the min fucntion. I just tweaked it not to create a new table
MIN ( Input[First Start], Input[Second Start] ) )
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |