Forum Discussion

steambucky's avatar
steambucky
Icon for Helper III rankHelper III
8 years ago

Meauring time and months AND if statements.

Hello :)   This measure I wrote helps work out the data’s age in months   _Months_of_age = DATEDIFF(MAX(SIR_XLS[Rev_Date]),TODAY(),MONTH)   What I would like is something that, where there IS a...
Need Help
steambucky's avatar
steambucky
Icon for Helper III rankHelper III
8 years ago

Is this heading in the right direction?

 

_Months since reviewed FIX =
IF (
    (SIR_XLS[Rev_Date])=blank,
    "NO DATE",
 DATEDIFF(MAX(SIR_XLS[Rev_Date]),TODAY(),MONTH)
)

 

Its still not working though...