Forum Discussion

Daniel___'s avatar
Daniel___
Frequent Visitor
1 year ago
Solved

DAx Support on cartesian table

Hello all,   Would like to get you support for a Dax formula. Teorical concept: there are two tables with data one Cost centers (D_CC_Costs) with Expenses and other table the final oucome of alloca...
  • Daniel___'s avatar
    Daniel___
    11 months ago

    Hi @lbendlin , Hi @v-lgarikapat ,

     

    Thank you both for the time/patience and the support. I was able to figure out the way :).

     

    So, Calculate + sumx + all is the key to be able to repeat over the rows te same amount in a cartesian table.

     

     

    Thank you

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi Daniel___ ,

We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.

 

Best Regards,

Lakshmi

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi Daniel___ ,

We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.

 

Best Regards,

Lakshmi

  • Daniel___'s avatar
    Daniel___
    Frequent Visitor
    11 months ago

    Hi @v-lgarikapat ,

     

    Link for PBI file: "https://drive.google.com/file/d/1deO9MnhJA_6DoITfBfzNBawEklG50oUl/view?usp=sharing".

     

    So the goal here is create a Cartesian table with all the combinations of tables names started by MD*, Then will need to have the same value on a row level when the follow combination match MD_CC and MD_Dates (the sumx would be from the table D_CC_Actuals).

    Example as below:

    MD_CC_AC                | MD_Dates   | MD_CC            |MD_PC                | Amount (Intention)

    Bought in D&D         | 001.2025      | 1060070300   | 5311010119       | 811145

    Communications       | 001.2025      | 1060070300   | 5311010119       | 811145

    Bought in D&D         | 002.2025      | 1060070300   | 5311010119        | 730031

    Communications       | 002.2025      | 1060070300   | 5311010119        | 730031

    Bought in D&D         | 001.2025      | 1060070300   | 5311110125       | 811145

    Communications       | 001.2025      | 1060070300   | 5311110125       | 811145

    Bought in D&D         | 002.2025      | 1060070300   | 5311110125        | 730031

    Communications       | 002.2025      | 1060070300   | 5311110125        | 730031

     

     

    Let me know in case you have some question.

     

    Thank you

      • Daniel___'s avatar
        Daniel___
        Frequent Visitor
        11 months ago

        Hi @lbendlin , Hi @v-lgarikapat ,

         

        Thank you both for the time/patience and the support. I was able to figure out the way :).

         

        So, Calculate + sumx + all is the key to be able to repeat over the rows te same amount in a cartesian table.

         

         

        Thank you