Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello All,
I am very new to Power BI and I am trying to create some calculations by using the formula PREVIOUSMONTH. However, every time I tried using different data, I kept getting the same error: "The visual calculation 'Formula' has a syntax or semantic error at line 1, position 39 reported by Analysis Services. 'A table expression containing more than one column was specified in the call to function PREVIOUSMONTH, which is not supported.
Here is my table and my formula :
I am trying to create a formula to show the value from the prervious month.
Thank you in advance for your help
Solved! Go to Solution.
The PREVIOUSMONTH DAX function needs a date column, not a column with month values.
The PREVIOUSMONTH DAX function needs a date column, not a column with month values.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
37 | |
30 | |
18 | |
14 | |
8 |
User | Count |
---|---|
50 | |
39 | |
32 | |
15 | |
13 |