Forum Discussion
Solved
Problems getting numbers displayed due to relationship problems (and that's not my wife!)
This is is pretty hard to expalin so created a small version of the file at this location Model Sales Pipeline contains a list of deals QB time contains timesheets for time spent on each deal ...
I got it working having suddenly hada brain wave. I had to convert my column value Sales Pipeline[Earliest date] intoa measure [Project start Date] so I could use it in a filter on the Datetable.
Project Est Hours = CALCULATE(SUM('Sales Pipeline'[Est Hours]), FILTER( ALL(DateTable), DateTable[Day]>=[Project start Date] && DateTable[Day]<=MAX(DateTable[Day]) ), USERELATIONSHIP('Sales Pipeline'[Earliest Date],DateTable[Day]) )
Hi masplin ,
I'm also researching in your needs. See if this thread can help you:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I got it working having suddenly hada brain wave. I had to convert my column value Sales Pipeline[Earliest date] intoa measure [Project start Date] so I could use it in a filter on the Datetable.
Project Est Hours = CALCULATE(SUM('Sales Pipeline'[Est Hours]),
FILTER(
ALL(DateTable),
DateTable[Day]>=[Project start Date] &&
DateTable[Day]<=MAX(DateTable[Day])
),
USERELATIONSHIP('Sales Pipeline'[Earliest Date],DateTable[Day])
)