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
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.