Using the rankx function inside a date table

akhaliq7 — Thu, 01 Jun 2023 09:22:02 GMT

I am defining a date table using dax and instead of creating a seperate calculated column would like to add the following code with the date table code definition.

my calc col using rankx

Date Rank = RANKX ( 'Date', FORMAT ( 'Date[Date], "YYYYMM" ),, ASC, Dense )

I want to add this to the date table code not as a calculated column but within the following code:

ADDCOLUMNS ( CALENDARAUTO (), "Year", YEAR ( [Date] ), "Quarter", "Q" & QUARTER ( [Date] ), "Month", FORMAT ( [Date], "mmmm" ), "Month Number", MONTH ( [Date] ) )

Re: Using the rankx function inside a date table

tamerj1 — Thu, 01 Jun 2023 11:01:32 GMT

HI akhaliq7

Please use

Date = VAR T = CALENDARAUTO () RETURN ADDCOLUMNS ( T, "Year", YEAR ( [Date] ), "Quarter", "Q" & QUARTER ( [Date] ), "Month", FORMAT ( [Date], "mmmm" ), "Month Number", MONTH ( [Date] ), "Date Rank", RANKX ( T, FORMAT ( [Date], "YYYYMM" ),, ASC, DENSE ) )

topic Re: Using the rankx function inside a date table in DAX Commands and Tips

Using the rankx function inside a date table

Re: Using the rankx function inside a date table