Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am not sure which forum to post this question as I couldnt find the one for Power Pivot in Excel. Power BI Desktop is very familiar with me but I am still exploring Power Pivot. Basically, what I am trying to do is create a calculated table in Power Pivot but I can't find this option. I don't even know if it is possible.
Proud to be a Super User!
it is possible to create it using Excel as well.
You need to go to Data > Existing Connections > Tables > then select one table from the data model ( a small one and import it into excel )
Afterwards, right click this table and choose
Write your query and then import this table into the Data Model
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
I have exactly this use case. I created a dummy table and imported it into the model.
Problem: Excel does not allow me to import Model data as Table. Table option is grayed out. Only allows Pivots. Do you know how to overcome this?
I found out why it did not allow to Import as table, but it still does not work. 🤷♀️
Following your guide:
Then it can be imported as a Table
I'm pretty sure the DAX is correct, because column BusinessCatalogs[Business Role ID] does exist.
Just to close the loop on this, You need to add the expression "EVALUATE" at the beginning of the Values statement.
Hi @LivioLanzo,
Thanks for the response. What I am trying to do is create a caclulated table from an already existing table.
Proud to be a Super User!
IF you want to use DAX then you need to import the original table into the Data Model and follow the process I described above
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |