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 want to create a measure which gives the next date in the column for the entityID in that row. For instance, in the table below, I want a new column which, let's say entity ID 92 the date is 29/06/2021 then it needs to give the date 29/09/2021.
Solved! Go to Solution.
@Annemie19 You can use this:
Column =
VAR CurrentRowEntity = Anne[EntityID]
VAR CurrentRowDate = Anne[MeasurementDate]
VAR SameRows =
FILTER (
Anne,
Anne[EntityID] = CurrentRowEntity
&& Anne[MeasurementDate] > CurrentRowDate
)
VAR Result =
MINX ( SameRows, Anne[MeasurementDate] )
RETURN
IF ( Result = BLANK (), CurrentRowDate, Result )
@Annemie19 You can use this:
Column =
VAR CurrentRowEntity = Anne[EntityID]
VAR CurrentRowDate = Anne[MeasurementDate]
VAR SameRows =
FILTER (
Anne,
Anne[EntityID] = CurrentRowEntity
&& Anne[MeasurementDate] > CurrentRowDate
)
VAR Result =
MINX ( SameRows, Anne[MeasurementDate] )
RETURN
IF ( Result = BLANK (), CurrentRowDate, Result )
@Annemie19 , try a new column like
minx(filter(table, [entityID] = earlier([entityID]) && [measuredate] >earlier([measuredate])),[measuredate])
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |