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

Hey TomasAndersson , 

 

thank you very much so far. I really appreciate it. I got one step closer to the solution. 

 

But your solution doesnt offer the right aggregation right now. My expectation for May 2022: 

 

300 Sales per Day over 31 Days --> 9.300 Sales (to be shown in the visualization)