Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Can anyhone see what is wrong with this calculation... deos not seem to be working..
Previous Month := CALCULATE(SUM(Query[Net]),PREVIOUSMONTH(Table2[Date]))
Error message is saying the expression is not valid and the syntax for '(' is incorrect.
Thanks
Solved! Go to Solution.
HI @Anonymous,
DAX formula is correct and no syntax error
Please, check your Query and Table2 connection in relationship. It may be possibility that you haven't marked your date table as "Mark as a date table". Time intelligence function will only work if your custom date table is marked with "Mark as a date table"
Thanks,
Amit
Hi @Anonymous,
Based on my test, it could work on my side:
Could you please share your file to have a test?
Regards,
Daniel He
Hi Dan,
Was missing the relationship .. fixed now.;
Thanks
@Anonymous
The syntax looks correct.
Need to check the connection between the tables Query and Table2
Also make sure you dont have any redundant brackets in the formula
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |