Need to Duplicate the row items based on an opportunity number. Split the opportunity value

[Supreeth]

Currently I have and Opportunity table. For an account the revenue will be tagged to a single region. Now i need to split the opportunity value between two regions with 50% revenue. How can this be achieved?

[pankajnamekar25 · Accepted solution]

Hello @Supreeth 

You can create calculated table

Opportunity_Split =

VAR Regions = {"APAC", "EMEA"}

RETURN

ADDCOLUMNS (

    GENERATE (

        Opportunity,

        SELECTCOLUMNS (

            Regions,

            "Region_Split", [Value]

        )

    ),

    "Revenue_Split", [Revenue] / 2

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[v-aatheeque]

Hi @Supreeth 

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!
 

[v-aatheeque]

Hi @Supreeth ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @Supreeth ,

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!