Forum Discussion

Diportee97's avatar
Diportee97
Icon for Helper I rankHelper I
1 year ago

Previous month dax issue

Hello guys,hope you are all well,i'm having problem with my previous month measure,the value shows for 2023 but shows blank when i click 2004,please what is the issue and solution 

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi  Diportee97 ,

     

    According to the pbix file you provided, when the slicer selects Year =2023, you have _date=2022.12.1 and EOMONTH(_date,-1)=2022.11.30 in your dax, but there is no data for the year 2022 in your table sales_data, and the smallest time is from 2023.1.1. So [Previous Month Sales] doesn't get the corresponding data, so the result is blank.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Diportee97's avatar
      Diportee97
      Icon for Helper I rankHelper I
      1 year ago

      So what do you suggest i do? Should i remove the -1 from the EOMONTH to balance everything?