As I sit here waiting for my Power pivot data refresh to update I am wondering if I should really be doing all the data manipulation in Power Query.
I created several tables to translate keys to the full description in PP eg 2074 ---> Ku-ring-gai Council etc and I use the relationships to provide data in the reports created via the pivot tables.
I have 18 tables some with 140,000 rows all index tables less than 100 rows.
(40 mins and still updating!)
Does anyone have an opinion regarding this??
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest