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 there,
I'm trying to create a measure that returns the minimum date if two or more records have the same ID and AuthorisationType is equal to 2 or 11. I wrote a measure which is as follows:
The above measure does not return the desired result. For example, as shown in the following picture, record ID 108644 has two dates and the measure did not return the min date.
Could anyone help me where I made the mistake?
Sample file here
Solved! Go to Solution.
Hi,
Drag ID to the visual and write this measure:
Min Date = CALCULATE(Min(Table[EffectiveDate]),Table[AuthorisationTypeID] = 11 ||Table[AuthorisationTypeID]=2)
@Dunner2020 please try this
Measure3 =
MINX (
FILTER ( 'Table', 'Table'[AuthorisationTypeID] IN { 2, 11 } ),
VAR _0 =
CALCULATE ( MAX ( 'Table'[ID] ) )
VAR _1 =
CALCULATE ( MIN ( 'Table'[EffectiveDate] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
VAR _2 =
CALCULATE (
MIN ( 'Table'[EffectiveDate] ),
TREATAS ( { ( { _0 }, { _1 } ) }, 'Table'[ID], 'Table'[EffectiveDate] )
)
RETURN
_2
)
Hi,
Drag ID to the visual and write this measure:
Min Date = CALCULATE(Min(Table[EffectiveDate]),Table[AuthorisationTypeID] = 11 ||Table[AuthorisationTypeID]=2)
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |