Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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]
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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]
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |