SELECTCOLUMNS in CROSSJOIN to rename a column

[sabilahmed]

Hi guys,

Is there a way to use SELECTCOLUMNS in a CROSSJOIN to rename the StartofMonth column so we can make this CROSSJOIN work? See below my DAX and error message:

Contracted & Uncontracted 2 = CROSSJOIN('Contracted & Uncontracted',SUMMARIZE(FILTER('Dim_Calendar','Dim_Calendar'[Date] > MIN('Contracted & Uncontracted'[END_DATE]) && 'Dim_Calendar'[Date] < MAX('Contracted & Uncontracted'[Today + 3 Years])), Dim_Calendar[StartofMonth]))

Thanks in advance.

S

[Jihwan_Kim · Accepted solution]

Hi,

Please try the below if it works.

Contracted & Uncontracted 2 =
CROSSJOIN (
    'Contracted & Uncontracted',
    SELECTCOLUMNS (
        SUMMARIZE (
            FILTER (
                'Dim_Calendar',
                'Dim_Calendar'[Date] > MIN ( 'Contracted & Uncontracted'[END_DATE] )
                    && 'Dim_Calendar'[Date] < MAX ( 'Contracted & Uncontracted'[Today + 3 Years] )
            ),
            Dim_Calendar[StartofMonth]
        ),
        "@NewNameStartofMonth", Dim_Calendar[StartofMonth]
    )
)