DAX DATESINPERIOD moving to different measure issue

[lemaribdb]

Hi guys!

I have below DAX measure and it works correctly.

Date Range Text =

VAR MaxDate = MAX(X_Calendar[DATE])

VAR SelectedPeriod = 'X_Relative Period'[Selected Months Back Number]

VAR Range = DATESINPERIOD('X_Relative Calendar'[DATE], MaxDate, -SelectedPeriod, MONTH)

VAR StartDate = MINX(Range, 'X_Relative Calendar'[DATE])

VAR EndDate = MAXX(Range, 'X_Relative Calendar'[DATE])

RETURN

FORMAT(StartDate, "yyyy-MM") & " to " & FORMAT(EndDate, "yyyy-MM") 

I wanted to move the 3 VARS (so the VAR Range output) to different measure so it can be used by few other measures. When I split this measure into two measures:

Selected Period Range =

VAR MaxDate = MAX(X_Calendar[DATE])

VAR SelectedPeriod = 'X_Relative Period'[Selected Months Back Number]

VAR Range = DATESINPERIOD('X_Relative Calendar'[DATE], MaxDate, -SelectedPeriod, MONTH)

RETURN Range

AND

X_SW Amount Rounded No Zero Relative =

VAR Range = 'X_Relative Period'[Selected Period Range]

RETURN

CALCULATE(

    X_Measures[X_SW Amount Rounded No Zero],

    REMOVEFILTERS(X_Calendar),

    KEEPFILTERS(Range),

    USERELATIONSHIP(X_Calendar[DATE], 'X_Relative Calendar'[DATE]))

I get an error "The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column". Can you advise my why this happens and how to fix it? To my understanding I just split the measure into two. I tried troubleshooting this by creating a calculated column out of the 'Selected Period Range' and apparently a new column with date hierarchy appears there. Can you help me?

[some_bih · Accepted solution]

Hi @lemaribdb 

It seems that in part X_SW Amount Rounded No Zero Relative =

VAR Range = 'X_Relative Period'[Selected Period Range] 

is issue

try to change this, maybe min or max, like VAR Range =MAX( 'X_Relative Period'[Selected Period Range])