Wyn - Power BI & Excel exceleratorbi.com.au
When to Create a Lookup Table in Power Pivot
Lookup table in Power Pivot, data model, Inbuilt time intelligence functions, Simplify DAX formulas, dimension tables, Multiple data tables, business logic.
Please switch to https://bsky.app/profile/did:plc:3ba3x52oyi327cwpdn3sotws/feed/PowerQuery by https://bsky.app/profile/unpivotshow.bsky.social // Made at BlueskyFeeds.com
Feed on BlueskyFeeds Stats
- 💙 Liked by 6 users
- 📅 Updated 10 months ago
- ⚙️ Provider blueskyfeeds.com
PowerQuery (Deprecated) Likes over time
Like count prediction
The feed PowerQuery (Deprecated) has not gained any likes in the last month.
Feed Preview for PowerQuery (Deprecated)
Combinar TODOS los archivos de una carpeta en Power Query, en una línea:
Folder.Files("C:\ruta") — carpeta local
SharePoint.Files("https://...") — SharePoint
Filtras por tipo y expandes con File.Contents. Adiós macros 👋
influexcel.com #Excel #PowerQuery
0
0
0
In a #PowerBI or #Excel #PowerPivot #DataModel, there are 2 types of tables:
1️⃣Dimension (aka Lookup) tables
2️⃣Fact (aka Data) tables
Here, Matt Allington explains when to create a Lookup table and when it's fine to use native columns in a data table: exceleratorbi.com.au/crea….
#PowerQuery
0
0
2
📩A new edition of our newsletter has just been sent, so time to check your inbox if you're a subscriber!
If not, sign up at skw-t.com/news to stay up-to-date on expert content, what's new in #Excel and #PowerBI, info on courses, events, specials, and more! Plus, get our free #PowerQuery eBook. 🤓
0
0
2