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
NewEntryDate =
VAR _CurrentMonth = SELECTEDVALUE(ReportingDate[ReportingDate])
RETURN
CALCULATE(
MAX(CashFlows[EntryDate]),
DATESINPERIOD(
CashFlows[EntryDate],
_CurrentMonth,
-1,
QUARTER
)
)