Forum Discussion

Lijun_'s avatar
Lijun_
New Member
2 years ago

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...
lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
2 years ago

Did you mark the "Date table" as a Date table? 🙂

Lijun_'s avatar
Lijun_
New Member
2 years ago

Hi thank you for replying, I did mark the date table as date table. Forgot to mention, I am need to show sales by month-year