how to split value approved and Non approved

Question

&nbsp; i have table that table&nbsp; have actauls value its combine values for both approved and non approved&nbsp;&nbsp;&nbsp;TABLE 1 :&nbsp;&nbsp;Company Code&nbsp; &nbsp; &nbsp; M1&nbsp; &nbsp; &nbsp; &nbsp; M2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ACTUALS&nbsp;&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&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&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;&nbsp;Another sheet table&nbsp;&nbsp;ComanyCode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved and NotApproved&nbsp;1A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved&nbsp;&nbsp;2A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;NotApproved&nbsp;&nbsp;5A04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Approved&nbsp;&nbsp;now i want final output like&nbsp;&nbsp;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;&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&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&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&nbsp;&nbsp;i have tired lookup function but norking .any idea please&nbsp;

jos_woolley · Answer

Hi,Assuming your tables are appropriately related, just add a couple of calculated columns:Approved =
IF ( RELATED ( 'Table'[Approved and Not Approved] ) = "Approved", [ACTUALS], 0 )Similar construction for Not Approved.Regards

anonymous · Answer

Hi ..getting error paramater is correct&nbsp;

Forum Discussion

how to split value approved and Non approved

2 Replies

Related content

Approval Status odata_ModerationStatus is only Approved

Power BI Workspace Server Request Approvals

Status rows = (ex) Approved, Approved, Rejected, Approved -------> Measure Returns "Rejected"

Approval workflows

Calculating Approval Percentage