IF in calculated column

[ndris]

Hi , 

Please I need your help , 
I have 2 tables : 

- Cashflows

Fund

EntryDate 

Commitment

- ReportingDate

Reportingdate
reportingdate Q-1

these two tables are not linked in my model .

I want to get im matrix this 

fund

entrydate

Newcolumn

New column is based on the value selected in my slicer (slicer contains reporting date ) 
And I want to get True Or False in Newcolumn if Entrydate is between ReportingDate and ReportingdateQ-1.

I was test many measure but it don't work:

NewCommitment =

var rd = SELECTEDVALUE(ReportingDate[ReportingDate])

var rdM1 = PREVIOUSQUARTER(ReportingDate[ReportingDate])

var entrydate= MAX(CashFlows[EntryDate])

return IF( entrydate < rd && entrydate > rdM1 ,"True","False")

Thanks 

[ndris · Accepted solution]

NewEntryDate =

VAR _CurrentMonth = SELECTEDVALUE(ReportingDate[ReportingDate])

RETURN

CALCULATE(

MAX(CashFlows[EntryDate]),

DATESINPERIOD(

CashFlows[EntryDate],

_CurrentMonth,

-1,

QUARTER

)

)

[ADPowerBI1]

NewCommitment = VAR rd = SELECTEDVALUE(ReportingDate[ReportingDate]) VAR rdM1 = PREVIOUSQUARTER(ReportingDate[ReportingDate]) VAR filteredDates = FILTER(ReportingDate, ReportingDate[ReportingDate] = rd || ReportingDate[ReportingDate] = rdM1) RETURN SWITCH(TRUE(), AND(MIN(filteredDates[ReportingDate]) <= MAX(CashFlows[EntryDate]), MAX(CashFlows[EntryDate]) <= MAX(filteredDates[ReportingDate])), "True", "False" )

Please try this measure 🙂 

[ndris]

Hi 

Thanks for your answer . But i have the below error : 

Kinds