topic Re: how to split value approved and Non approved in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-split-value-approved-and-Non-approved/m-p/2034791#M45643 <P>Hi ..</P><P>getting error paramater is correct&nbsp;</P> Tue, 24 Aug 2021 11:23:27 GMT Anonymous 2021-08-24T11:23:27Z how to split value approved and Non approved https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-split-value-approved-and-Non-approved/m-p/2034674#M45640 <P>&nbsp; i have table that table&nbsp; have actauls value its combine values for both approved and non approved&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>TABLE 1 :&nbsp;</P><P>&nbsp;</P><P>Company Code&nbsp; &nbsp; &nbsp; M1&nbsp; &nbsp; &nbsp; &nbsp; M2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ACTUALS&nbsp;</P><P>&nbsp; 1A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 453</P><P>&nbsp; 2A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;234</P><P>&nbsp; 5A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;134&nbsp;</P><P>&nbsp;</P><P>Another sheet table&nbsp;</P><P>&nbsp;</P><P>ComanyCode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved and NotApproved&nbsp;</P><P>1A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved&nbsp;</P><P>&nbsp;</P><P>2A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;NotApproved&nbsp;</P><P>&nbsp;</P><P>5A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved&nbsp;</P><P>&nbsp;</P><P>now i want final output like&nbsp;</P><P>&nbsp;</P><P>Company Code&nbsp; &nbsp; &nbsp; M1&nbsp; &nbsp; &nbsp; &nbsp; M2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved&nbsp; &nbsp; NotApproved&nbsp;</P><P>&nbsp; 1A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;453&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0</P><P>&nbsp; 2A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 234</P><P>&nbsp; 5A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 134&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0</P><P>&nbsp;</P><P>&nbsp;</P><P>i have tired lookup function but norking .any idea please&nbsp;</P> Tue, 24 Aug 2021 10:35:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-split-value-approved-and-Non-approved/m-p/2034674#M45640 Anonymous 2021-08-24T10:35:29Z Re: how to split value approved and Non approved https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-split-value-approved-and-Non-approved/m-p/2034708#M45641 <P>Hi,</P><P>Assuming your tables are appropriately related, just add a couple of calculated columns:</P><LI-CODE lang="markup">Approved = IF ( RELATED ( 'Table'[Approved and Not Approved] ) = "Approved", [ACTUALS], 0 )</LI-CODE><P>Similar construction for Not Approved.</P><P>Regards</P> Tue, 24 Aug 2021 10:52:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-split-value-approved-and-Non-approved/m-p/2034708#M45641 Jos_Woolley 2021-08-24T10:52:09Z Re: how to split value approved and Non approved https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-split-value-approved-and-Non-approved/m-p/2034791#M45643 <P>Hi ..</P><P>getting error paramater is correct&nbsp;</P> Tue, 24 Aug 2021 11:23:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-split-value-approved-and-Non-approved/m-p/2034791#M45643 Anonymous 2021-08-24T11:23:27Z