Forum Discussion

norbi's avatar
norbi
Icon for Helper I rankHelper I
8 years ago

Annual percentage split on different items and split value accordingly

Hi, I would truly appreciate some help with the following challenge. I have a total val for a year and the percentage split over the period. I would like to combine these where Table_1 would have th...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

norbi

 

Hi:

 

Try with;

 

Modeling - New Table

 

Cruce = CROSSJOIN(Table1,Table2)

 

After that created a calculated column with 

 

NVal = Cruce[Val]*Cruce[%_Trend]

 

Regards

Victor

norbi's avatar
norbi
Icon for Helper I rankHelper I
8 years ago

Hi Vvelarde,

 

I am a bit new to Power BI, could you kindly elaborate or provide a sample Power BI file?

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    norbi

     

    Please review the PBIX

    Here

     

    Let me know if works for your question

     

    Regards

     

    Victor

    Lima - Peru

    • norbi's avatar
      norbi
      Icon for Helper I rankHelper I
      8 years ago

      Hi Vvelarde,

       

      No the file does not work and does not open?

      • Vvelarde's avatar
        Vvelarde
        Icon for Community Champion rankCommunity Champion
        8 years ago

        norbi

         

        Try Downloading and Opening with PBI Desktop November Update.

         

        Regards