Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I've spent some time trying to come up with some logic, however I can't seem to get anywhere with it.... hopefully one of you can help.
Below is a sample table, which shows the date that a piece of work was "received" and the date that it was completed ("Closed"). Each 'Case ref' is given a value ('Bulk Count') of 1 in this example, however in the real dataset this could be any number.
[CASES TABLE]
If the date in the below table is the => than the Received date and < Closed date, then I want to sum all the row values in the Bulk Count column, where that condition is met.
[DATE TABLE]
So, the final table should look something like this;
Sorry if that doesn't make any sense, my brain is a little fried. Please ask questions if you need any clarification.
Thanks in advance.
Try to create a measure like this:
Measure = CALCULATE(SUMX(FILTER(ALL('Table'),'Table'[Received]<=MAX('Table 2'[Date])&&'Table'[Closed]>=MAX('Table 2'[Date])),'Table'[Bulk count]))
Best regards
Liang
If this post helps, then consider Accept it as the solution to help other members find it faster.
@Hundoa , refer my HR blog on similar type of data.
video -https://www.youtube.com/watch?v=e6Y-l_JtCq4
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |