Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Past Data not appearing in Matrix

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!

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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])
    )
    )
     

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous ,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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])
      )
      )