This is one of the most useful vedios I have ever watched on power bi on KZfaq.
@oscarestorach61624 ай бұрын
You are great, thanks a lot to share your knowledge
@OA-lx2zr Жыл бұрын
Best SCD video ive seen
@shafa76682 жыл бұрын
Fantastic vedio. Thanks for doing it.
@fadwa24132 жыл бұрын
Keep Going to learn us ,Please Perfect as Always
@pietjehans2062 жыл бұрын
Thanks, I needed an example of SCD in PBI. Disadvantage of this method is that in order to avoid circular dependency, you need a reference table for each dimension table in your data model. The better option is perhapse to create the index column on the fact table in PowerBI. Perhaps there is an even better solution?
@ethugp3pp3r2 жыл бұрын
That is where I think I would have taken a different direction, too. I don’t really like creating Dax tables unless they´re dates…
@cornel49313 жыл бұрын
Hey, thanks so much for this content. The guide clearly knows his way around. Has any encountered an error with circular dependency? Since we create the index col on the fact is using the dim table that causes an error when trying to create a relationship.
@IlariaLongoDorni3 жыл бұрын
thanks, it solved me a big doubt.
@LondonBusinessAnalyticsGroup3 жыл бұрын
Happy to help
@gauravsingh-jh7pz3 жыл бұрын
Hi, I was unable to get the total value of JEN (Current revenue ) is there any specific setting we have to do while activating the relationship???
@dimitridelizee4032 Жыл бұрын
Thank you for the video. The link seems broken. Can you reload it, please ?
@TheGlassGalaxy2 жыл бұрын
thanks sir, is it possible for you to share the link for the tables that you have used so that we can practice the same?
@LondonBusinessAnalyticsGroup2 жыл бұрын
here it is github.com/MarkWilcock/lbag-online/tree/master/Slowly%20Changing%20Dimensions
@pieterlinden8292 Жыл бұрын
Are the data files available somewhere? The link for them is broken. =(
@IlariaLongoDorni3 жыл бұрын
Hi Chris, how could I manage this: I have more than one event (for example 3) in the historical table related to Territory and with the same date. the reference table will correctly show 3 different lines but into the sales table the index number will be only the first one that it founds. I cannot create a bridge table with unique value for historical data because I will lose details that I need. I have tried with rank but many to many relationship are not allowed.thanks
@chrisbarber6393 жыл бұрын
This is a hard question to answer without seeing the data. In the case of SCD you want a one to many relationship flowing from the dimension to the fact table. Look at an example record which is causing the many to many, decide on which of those rows which you want to filter the fact table and then look at what else you have in the dimension to distinguish that row.
@IlariaLongoDorni3 жыл бұрын
@@chrisbarber639 Hi Chris, thanks for answering. I solved it in this way: I copied the territory table (copy as reference) and deleted details that I didn't need in the first table. in this way I could connect the sales table and territory. then I connected territory table with the one with details. it works :)