Skip to main content
cancel
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

Reply
THENNA_41
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 

2 REPLIES 2
Jos_Woolley
Solution Sage
Solution Sage

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

Hi ..

getting error paramater is correct 

Helpful resources

Announcements
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