Forum Discussion
MikeHendriks
Helper I
1 year agoCorrupt Excel Pivottable; same number on all months
We have some Excel files connected to a semantic model hosted in Power BI. Worked perfect for long period but since a week we get users complaining about a behaviour that is completely wrong; the tot...
- 1 year ago
Issue is fixed. It seems to be caused by a DAX statement with a filter on the monthnumber which gives back different values for the same DAX statement with the same pivottable. Very strange, but fixed it with KEEPFILTERS.
v-saisrao-msft
Community Support
1 year agoHi MikeHendriks,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.