Forum Discussion
Solved
Generate Series Based on Table (2 Columns)
Hi Team, I am looking at generating a series of columns based on a table as per below. Table: Trading Name Open Date End Date Centre 1 2/05/2020 2/08/2020 Centre 2 24/08/202...
Thanks for all the responses. I was able to figure this out by just generating the series with the above dax query I mentioned. I then just created a rank column to get the sequence of dates.
Rank =VAR D = 'Result Table'[Value]VAR C = 'Result Table'[Label]RETURNCALCULATE(RANK.EQ(D, 'Result Table'[Value], ASC),FILTER(ALL('Result Table'), 'Result Table'[Label] = C))
markjdm_17 , refer to my HR blog. Seems that can help
Thanks for all the responses. I was able to figure this out by just generating the series with the above dax query I mentioned. I then just created a rank column to get the sequence of dates.
Rank =
VAR D = 'Result Table'[Value]
VAR C = 'Result Table'[Label]
RETURN
CALCULATE(
RANK.EQ(D, 'Result Table'[Value], ASC),
FILTER(ALL('Result Table'), 'Result Table'[Label] = C)
)
Hi markjdm_17 ,
Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly. Your contribution is highly appreciated.
Best Regards,
Icey
