Search found 3 matches

by TonyAMP
Wed Sep 25, 2019 10:53 am
Forum: Power Query
Topic: Delete Add Tables from Power Query
Replies: 1
Views: 436

Delete Add Tables from Power Query

Hi, I have several monthly tables and an annual consolidated table, where I add each table month by month. However, in my model, there are several queries, these monthly tables, without need, and I can not delete them. Since I add queries I can not delete the tables that have been added? Sem título....
by TonyAMP
Wed Sep 25, 2019 10:31 am
Forum: PowerPivot/DAX
Topic: Only Fact Table on the Model [Solved]
Replies: 2
Views: 602

Re: Only Fact Table on the Model [Solved]

Yes you can. You can use a single flat table if you want. The best design is a star schema. Generally it is the best trade off for compression, efficiency and simplicity With the DAX. Matt, Thanks so much for the advice! Whether the Starchema or Snow Flake model can be used, but no information has ...
by TonyAMP
Fri Sep 20, 2019 1:11 pm
Forum: PowerPivot/DAX
Topic: Only Fact Table on the Model [Solved]
Replies: 2
Views: 602

Only Fact Table on the Model [Solved]

Hello dear, I am a DAX newbie and would like to know if it is possible to use a data model with only a denormalized fact table and a calendar fact. Within the fact table, there are 20 columns. I know it is wise for me to slice the fact table and some more dimensions, but I had this question. Is it p...

Go to advanced search