Forum Discussion
Lijun_
2 years agoNew Member
Previousmonth syntax not working
Hello Guys, I am new to Power BI and run into this problem where the PREVIOUSMONTH sytax returns blank value. I have two tables: Sales Fact and Date Table. I've built the relationshion between these...
v-weiyan1-msft
Community Support
2 years agoHi Lijun_ ,
According to your description and the dax formula you provided, here is the test I did with my own sample, and there was no problem.
Since I don’t know the specific situation of your data, in order to help you better locate and solve these problems, I will attach my .pbix file to you. Please try to open it after you receive the file, and compare it with your data and file, to see if you can find any differences.
My Sample:
Result is as below.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.