Forum Discussion
Replicating an Excel table with calculated cells
Super UserAnonymous
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.
jdbuchanan71 Thanks a lot for tking the time to reproduce the tables. But My final table in PBI should be this:
With the formulas as below for each cell:
I took both screenshots from the excel sheet I shared via dropbox earlier.
Thanks!
- jdbuchanan71
Anonymous
I understand what you want the final table to look like. My picture is how you should set up the model so you can replicate your table in powerbi.