Forum Discussion
Replicating an Excel table with calculated cells
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
Super UserI 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.
jdbuchanan71Thanks!
but I already have it set in PBI since these 3 tables are exactly existed in the Exccel. My only questions was on how to make the same table in POWER QUERY Editor before importing it to POWER BI? I need to unpivot the final table in my model so I can use it for my next steps with other tables...
would appreciate a reply
Thanks again