Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Help appreciated
Help me
Help Requested
Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi ..

    getting error paramater is correct