Forum Discussion
Date Table Problem - Calculate Sum Missing Data Outside Filter Window
cdfizz17 , In this case date table filter is getting removed to calculate the prior period, but of period filter is not getting removed.
try if all period can help
TotalSalesOffset = CALCULATE(
[TotalSales],
DATEADD('Date'[Date],-1,MONTH), all(period)
)If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you for your response. The table 'Periods' is structured as below:
| Date | Filter |
| 2024/06/01 | Full Period |
| 2024/06/02 | Full Period |
| 2024/06/03 | Full Period |
| 2024/06/04 | Full Period |
| ... | ... |
| 2024/12/29 | Full Period |
| 2024/12/29 | Focus Period |
| 2024/12/30 | Full Period |
| 2024/12/30 | Focus Period |
| 2024/12/31 | Full Period |
| 2024/12/31 | Focus Period |
'Full Period' is intended to cross-filter every date.
'Focus Period' is intended to filter a sub-set of dates, e.g. Dec-24.
cdfizz17 , In this case date table filter is getting removed to calculate the prior period, but of period filter is not getting removed.
try if all period can help
TotalSalesOffset = CALCULATE(
[TotalSales],
DATEADD('Date'[Date],-1,MONTH), all(period)
)
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you, this fixed my problem.
Period filter needed to be removed 🙂