Past Data not appearing in Matrix

[darentengdrake]

Hi,

Assuming I have a set of forecast data ranging from January 2019 to December 2020.

I tried to create a matrix of the forecast data that I have. with each week being one forecast data, and several different items to forecast. However, the matrix that was created only contains data starting from the current month onwards and ignoring past months. When I try to apply a filter to get data from a past month, it does not show any data in the matrix.

These data are present in the table that has all the data which are loaded in Power BI.

Any thoughts?

Thanks!

[v-yulgu-msft]

Hi @darentengdrake ,

Please check if any page or report level filter is applied which might filter out data records in past months. 

How is your dataset look like? How do you create the Matrix? Is there any measure used? Please post sample data and screenshots.

Best regards,

Yuliana Gu

[darentengdrake · Accepted solution]

Hi @v-yulgu-msft 

Thanks for getting back.

I think I found out what may be causing the problem.

It feels like it is the DAX formula that we are using that is filtering out past data.

This is the measure I'm using

Net =

CALCULATE(

[Net],

FILTER(

ALLEXCEPT ( Forecast, Forecast[ITEM] ),

Forecast[Reqs Date] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1)

&&

Forecast[Reqs Date] <= MAX(Forecast[Reqs Date])

)

)