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

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

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

        I'm not sure how you would do that, sorry.