Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Partisan
Post Partisan

how to split value approved and Non approved

  i have table that table  have actauls value its combine values for both approved and non approved 



TABLE 1 : 


Company Code      M1        M2         ACTUALS 

  1A04                    5              6            453

  2A04                    15           16           234

  5A04                    25           36           134 


Another sheet table 


ComanyCode         Approved and NotApproved 

1A04                                   Approved 


2A04                                  NotApproved 


5A04                                   Approved 


now i want final output like 


Company Code      M1        M2                 Approved    NotApproved 

  1A04                    5              6                     453                      0

  2A04                    15           16                       0                      234

  5A04                    25           36                      134                    0



i have tired lookup function but norking .any idea please 

Solution Sage
Solution Sage


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.


Hi ..

getting error paramater is correct 

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors