Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi i have a very basic question that I am stuck on.
I have 2 columns from the same table.
Customer Date
Customer Date
1 2/2/2018
2 2/6/2018
3 2/9/2018
so I just want to create a column or measure which will look at each date and then say if it is the min or max date
Customer Date Status
1 2/2/2018 Min
2 2/6/2018
3 2/9/2018 Max
Solved! Go to Solution.
Hi @saanah2019
You may create a column like below:
Column = IF ( 'Table'[Date] = MAX ( 'Table'[Date] ), "MAX", IF ( 'Table'[Date] = MIN ( 'Table'[Date] ), "MIN", BLANK () ) )
Regards,
I ran into this same issue earlier today! I was able to find two solutions which I believe might work for you. I've included the code and link to the other post below. The first solution is through a calculated column and the second is via a measure.
Is Latest Row Filter = VAR LatestDate = MAXX(FILTER('Table1','Table1'[Type] = EARLIER('Table1'[Type])),'Table1'[Date]) RETURN IF('Table1'[Date]=LatestDate,1,0)
Measure = VAR LatestDate = CALCULATE ( MAX ( 'Table1'[Date] ), ALL ( 'table1' ) ) RETURN IF ( MIN ( 'Table1'[Date] ) = LatestDate, 1, 0 )
https://community.powerbi.com/t5/Desktop/Show-only-data-from-the-latest-date/m-p/443987#M205215
Hope these help.
Hi @saanah2019
You may create a column like below:
Column = IF ( 'Table'[Date] = MAX ( 'Table'[Date] ), "MAX", IF ( 'Table'[Date] = MIN ( 'Table'[Date] ), "MIN", BLANK () ) )
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |