Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

IF in calculated column

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 

fundentrydateNewcolumn

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 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago
    NewEntryDate =
    VAR _CurrentMonth = SELECTEDVALUE(ReportingDate[ReportingDate])
    RETURN
    CALCULATE(
    MAX(CashFlows[EntryDate]),
    DATESINPERIOD(
    CashFlows[EntryDate],
    _CurrentMonth,
    -1,
    QUARTER
    )
    )

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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 🙂 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi 

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

      Kinds

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago
    NewEntryDate =
    VAR _CurrentMonth = SELECTEDVALUE(ReportingDate[ReportingDate])
    RETURN
    CALCULATE(
    MAX(CashFlows[EntryDate]),
    DATESINPERIOD(
    CashFlows[EntryDate],
    _CurrentMonth,
    -1,
    QUARTER
    )
    )