https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Age-calculation/m-p/3145027#M112473 <P>Anonymous</LI-USER>&nbsp;Maybe:</P> <LI-CODE lang="markup">Column = SWITCH(TRUE(), [Status] = "Open", ( TODAY() - [Created Date] ) * 1., [Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1. )</LI-CODE> Tue, 21 Mar 2023 15:07:22 GMT Greg_Deckler 2023-03-21T15:07:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Age-calculation/m-p/3144893#M112460 <P>I have a sample table, in that i sales id i need to create the age for the sales id's as per the status</P><P>if the status is open</P><P>From "Created Date" till Today&nbsp; ; If CLOSED (WON or LOST)&nbsp; From "Created Date" till "WonLostDate"</P><P>&nbsp;</P><P>kindly help me on this&nbsp;</P><P>&nbsp;</P><P>need to write a measure</P> Tue, 21 Mar 2023 14:20:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Age-calculation/m-p/3144893#M112460 Anonymous 2023-03-21T14:20:34Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Age-calculation/m-p/3145027#M112473 <P>Anonymous</LI-USER>&nbsp;Maybe:</P> <LI-CODE lang="markup">Column = SWITCH(TRUE(), [Status] = "Open", ( TODAY() - [Created Date] ) * 1., [Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1. )</LI-CODE> Tue, 21 Mar 2023 15:07:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Age-calculation/m-p/3145027#M112473 Greg_Deckler 2023-03-21T15:07:22Z