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

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.