Forum Discussion
Solved
pivot table week month year sum
Hello, I want to calculate weekly, monthly, annual totals in pivot table. When I select week 8 from the filter section at the top, I want the monthly data to be collected until the 8th week of th...
Hi ferdiakinci ,
Your error message clearly tells you the error. You have a table called _month, so you can't define a variable. you can either change the name of the table _month, or you can change the name of the variable _month.
There is an error in this formula, please note the correction.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please provide some more details like data or just a snippet of data and more clearer requirements.