Hello Team,
I have net cases number pulled from daily invoice database. I want to show the net cases in the table as the table1 below based on the date range. However, I have used the measure as below but get the net cases combined instead of row by row. Can you please help me how to adjust my measure to get it to work? Thanks.
NetCases = calculate(sum('summary InvoiceDCByDay'[NetCases]),filter('Pricing',average('summary InvoiceDCByDay'[InvoiceDate])>=Pricing[Valid After] && average('summary InvoiceDCByDay'[InvoiceDate])<=Pricing[Valid Before]))
Net Cases | Price Start Date | Price End Date |
100 | 4/1/2019 | 5/1/2019 |
108 | 5/1/2019 | 6/1/2019 |
5 | 6/1/2019 | 7/1/2019 |
This one below is what it look like in my table, after the measure I enter:
| Adjusted Cases | Price Start Date | Price End Date |
| | 4/1/2019 | 5/1/2019 |
| 213 | 5/1/2019 | 6/1/2019 |
| | 6/1/2019 | 7/1/2019 |
