Forum Discussion
Rabi
Resolver I
Resolver IFortnight Dates from a Date Column
Hi everyone, I managed to get Group of weekly dates form jedate column, But i cant get it to group by fortnight, the result would be 1/1/2023 repeating 14 times and the next date repeating...
FortnightStartDate= VAR w = INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 ) RETURN MINX ( FILTER ( TableA, INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 ) = w ), [JEDate] )Legend, Thanks very much for your time lbendlin, I appreciate your help. There was slight issue with the dax,
FortnightStartDate= VAR w = INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 ) var x= MINX ( FILTER ( TableA, INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 ) = w && [jedate].[year]=2023 ), [JEDate] ) return, if([jedate].[year]=2023,x,blank())
lbendlin
Super User
Super UserFortnightStartDate=
VAR w =
INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 )
RETURN
MINX (
FILTER (
TableA,
INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 ) = w
),
[JEDate]
)
RabiResolver I
Resolver ILegend, Thanks very much for your time lbendlin, I appreciate your help. There was slight issue with the dax,
FortnightStartDate=
VAR w =
INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 )
var x=
MINX (
FILTER (
TableA,
INT ( WEEKNUM ( [JEDate] + 7, 1 ) / 2 ) = w && [jedate].[year]=2023
),
[JEDate]
)
return,
if([jedate].[year]=2023,x,blank())