Excel Formula is as below :
MATURITYFACTOR = =SQRT(MIN(([@[MATURITY_DATE]]-[@RUNDATE])/365,1)/1)
I tried implementing the below dax in Custom Column as below. But its throwing error. Any advise!
= Table.AddColumn(#"Reordered Columns", "MATURITYFACTOR", each Number.Sqrt(List.Min(([MATURITY_DATE]-[RUNDATE])/365,1)/1))
MATURITYFACTOR = =SQRT(MIN(([@[MATURITY_DATE]]-[@RUNDATE])/365,1)/1)
I tried implementing the below dax in Custom Column as below. But its throwing error. Any advise!
= Table.AddColumn(#"Reordered Columns", "MATURITYFACTOR", each Number.Sqrt(List.Min(([MATURITY_DATE]-[RUNDATE])/365,1)/1))