Forum Discussion

cdfizz17's avatar
cdfizz17
Frequent Visitor
1 year ago
Solved

Date Table Problem - Calculate Sum Missing Data Outside Filter Window

I have a Date table and a Sales table, with measures for Total Sales and 'Total Sales Offset' (Total Sales shifted by 1 month):   TotalSales = CALCULATE( SUM('Sales'[Total]) ) TotalSalesOffse...
Need Help
  • amitchandak's avatar
    amitchandak
    1 year ago

    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.

amitchandak's avatar
amitchandak
Super User
1 year ago

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.

cdfizz17's avatar
cdfizz17
Frequent Visitor
1 year ago

Thank you, this fixed my problem.

Period filter needed to be removed 🙂