Forum Discussion

ferdiakinci's avatar
ferdiakinci
Frequent Visitor
3 years ago
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...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.