https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-need-help-for-function/m-p/2978586#M99790 <P>What should the formula in Power BI look like if you always wanted to take the first two digits and if the second digit is a minus then the third and fourth digits as you can see in the attached screenshot.<img /></P> Tue, 20 Dec 2022 09:31:02 GMT Anonymous 2022-12-20T09:31:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-need-help-for-function/m-p/2978586#M99790 <P>What should the formula in Power BI look like if you always wanted to take the first two digits and if the second digit is a minus then the third and fourth digits as you can see in the attached screenshot.<img /></P> Tue, 20 Dec 2022 09:31:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-need-help-for-function/m-p/2978586#M99790 Anonymous 2022-12-20T09:31:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-need-help-for-function/m-p/2978805#M99804 <P>Anonymous</LI-USER>&nbsp;, try this calculated column:</P><P>&nbsp;</P><LI-CODE lang="markup">NewColumn = IF( MID('Table'[ExistingColumn', 2, 1) = "-", MID('Table'[ExistingColumn', 3, 2, LEFT('Table'[ExistingColumn',2) )</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Tue, 20 Dec 2022 11:12:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-need-help-for-function/m-p/2978805#M99804 Anonymous 2022-12-20T11:12:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-need-help-for-function/m-p/2991197#M100650 <P>Anonymous</LI-USER>&nbsp;, if my suggestion solved the problem you posted, then please mark the answer a Accept As Soultion. This helps other members that are searching for the same or similar problem know what worked.</P> Wed, 28 Dec 2022 06:53:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-need-help-for-function/m-p/2991197#M100650 Anonymous 2022-12-28T06:53:06Z