Forum Discussion

kastenkk's avatar
kastenkk
Frequent Visitor
1 year ago
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...
Show and Tell
  • kastenkk's avatar
    kastenkk
    1 year ago

    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



Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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