Forum Discussion
Diportee97
Helper I
Helper IPrevious 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
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.
Diportee97Helper I
Helper ISo what do you suggest i do? Should i remove the -1 from the EOMONTH to balance everything?