Forum Discussion
Replicating an Excel table with calculated cells
Super User
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 Thanks for the reply.
Here I shared the link to dropbox file I shared. If you have any problem let me know:
https://www.dropbox.com/s/22nirv4hbxx4wy1/recordheights.xlsx?dl=0
Looking forward to hearing from you
Thanks
- jdbuchanan71
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.
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
- jdbuchanan71
I would set it up like this:
Having the Contestant table at the top will help with the rest of the measures needed. Each of the formulas in the excel table is not unique, it is just in a different filter context which is what DAX does using measures.