Forum Discussion
Solved
Repeat a application from its starting point until the End of the year
Hello all, This is the current structure issue 1. The model is based on 2 fact table 1.1 Register of reason that a part price fluctuates (linked with reason itself and date of applicati...
Solution is as follow:
Result =FILTER(CROSSJOIN('(fact1)','(fact2)'),'(fact1)'[PartNumber]='(fact2)'[PartNumber_] && '(fact1)'[DateP]<='(fact2)'[DateP_])
and relation with caledar must be on "DateP_" at (fact2) table
Hi kastenkk,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Vinay Pabbu
Hi kastenkk,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Vinay Pabbu