Forum Discussion
Solved
How to get Previous Month Year
Hello Experts, I am new to Power BI, I have a requirement in which I ran a report for prior month, and I want to automate the year. I can easily do as format(today(),"YYYY") but the issue is that...
Read about DATEADD() - it allows you to do your shifts by month or by year etc.
It is mandatory that your data model includes a calendar table and that the time intelligence DAX is applied on that table.
lbendlin
Super User
Super UserRead about DATEADD() - it allows you to do your shifts by month or by year etc.
It is mandatory that your data model includes a calendar table and that the time intelligence DAX is applied on that table.