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