Forum Discussion
Anonymous
6 years agoNot applicable
Return dates when condition is met
Hello Community! A few days I go I finished an Udemy course "Microsoft Power BI - Up & Running With Power BI Desktop" Now it's time to use that knowledge it in real life and life is brutal! I hav...
Anonymous
6 years agoNot applicable
Thank you darlove for hints and links. I will definetelay watch both of the movies.
The bideractional relationship between the left and the middle table is necessary, without that I get completely wrong weights.
If I set it to one direction, the direction is from left to right. So it is FROM data table TO lookup table. Or... quasi lookup.
In data table are uniqe rows, the properties set for each object. Middle table stores the history of those objects, so it has multiple rown with the same objects, (1st row insertet, 2nd row modiefied, 3rd row modiefid, etc...)
Anyway, I will post in this thread any progress I will manage to make. With propre Tages It might help others in the future.
Regards, Nicram
Anonymous
6 years agoNot applicable
You should really learn about the proper dimensional design and the DANGERS of using bidirectional filters.
This is only one of many articles that can make you aware of potential traps:
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Best
D
This is only one of many articles that can make you aware of potential traps:
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Best
D