Forum Discussion

Lennard's avatar
Lennard
Frequent Visitor
3 years ago
Solved

selectedvalue doesnt work with date-aggregations

Hey there,    I have problems to solve the following task:   Ich have 2 Data Tables  1) --> TargetSalesPerDay for each Project 2) --> individual Project Start / End-Date I managed ...
  • Lennard's avatar
    Lennard
    3 years ago

    Solution: I worked it out with a vitual table: 

     

    Target_table=

        filter(
            filter(
                filter(
                    CROSSJOIN(Kalendar,ProjectAppointment,Project),
                Project[SalesProjectID]=ProjectAppointment[SalesProject]),
            Kalendar[Tag]>=ProjectAppointment[Start]),
        Kalendar[Tag]<ProjectAppointment[End])
     
    and the related measure: 
    Final_target = sum(Target_table[TargetSalesPerDay])
     
    Now it works!
     
    Best regards
Lennard's avatar
Lennard
Frequent Visitor
3 years ago

Solution: I worked it out with a vitual table: 

 

Target_table=

    filter(
        filter(
            filter(
                CROSSJOIN(Kalendar,ProjectAppointment,Project),
            Project[SalesProjectID]=ProjectAppointment[SalesProject]),
        Kalendar[Tag]>=ProjectAppointment[Start]),
    Kalendar[Tag]<ProjectAppointment[End])
 
and the related measure: 
Final_target = sum(Target_table[TargetSalesPerDay])
 
Now it works!
 
Best regards