Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |