Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Replicating an Excel table with calculated cells

Hi Gurus, I have an excel table with cells. in  each cell I have a round formula like the screenshot below and they get data from other tables in the same work sheet as you can see below. I know hav...
Need Help
Tips and Tricks
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

 

Anonymous wrote:

I have the Excel file but I don't know how to share it here?!

You can share it by uploading it to your https://www.dropbox.com account.

    • jdbuchanan71's avatar
      jdbuchanan71
      Icon for Super User rankSuper User
      7 years ago

      Anonymous 

      If this is going to be a PowerBI model we will need to see the .pbix file.  We can't help without knowing the structure of the model to know things like how the Girls data is coming in.  Please post a link to your Power BI file.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        jdbuchanan71,

        The short boys, medium boys, etc. are all calculated data in the table with the Round() excel formula. The only source which being used is the Contestant Excel table which you see in the same sheet that I have to use in my PBIX model and weeks number which are manual user inputs in the same table that below is the screenshot of both. The tables are all in the same Excel sheet that I shared earlier:

         

         

        Actually my question is how to design the model cause I am confused on how to reproduce the same table as Excel with each cell containing a unique formula!

        Thanks very much again