Forum Discussion

LaiqueMalik's avatar
LaiqueMalik
New Member
3 years ago

Assistance Required

Hi There, Hope everything is well. My humble reqeust to help in correction of the below query    Max_STime = IF(     ISBLANK(CALCULATE(COUNT(SAF_REPORT[Loan ID]))),     TIMEVALUE("00:00:00"), ...
Need Help
AjithPrasath's avatar
AjithPrasath
Resolver II
3 years ago

LaiqueMalik ,

  Please use the below code:

Max_STime =
IF(
    ISBLANK(CALCULATE(COUNT(SAF_REPORT[Loan ID]))),
    TIMEVALUE("00:00:00"),
    MAXX(FILTER(SAF_REPORT, NOT(ISBLANK(SAF_REPORT[Stage Time]))), SAF_REPORT[Stage Time])
)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍