DAX DATESINPERIOD moving to different measure issue

lemaribdb — Thu, 14 Mar 2024 09:58:01 GMT

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?

Re: DAX DATESINPERIOD moving to different measure issue

some_bih — Thu, 14 Mar 2024 11:58:24 GMT

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])

topic Re: DAX DATESINPERIOD moving to different measure issue in DAX Commands and Tips

DAX DATESINPERIOD moving to different measure issue

Re: DAX DATESINPERIOD moving to different measure issue